![siemens teamcenter clear cache siemens teamcenter clear cache](http://3.bp.blogspot.com/-bZB4W9DknSE/T14GxdF5W0I/AAAAAAAABCc/SfnTK9ptL9Y/s1600/screenshot.3.png)
- Siemens teamcenter clear cache how to#
- Siemens teamcenter clear cache full#
- Siemens teamcenter clear cache code#
Once again I found myself looking at tables in the database to find the information I needed. $query = "SELECT COUNT(*) FROM dbo.PPOM_SESSION" Get an accurate count of users logged into the Teamcenter Server. This cmdlet does not release locks of any dead sessions. This function does not replace list_users. This command does not output to the pipeline This command does not accept input from the pipeline Get-UserCount -ds vm-tcdb -u infodba -p infodba -d tc Get-UserCount -datasource vm-tcdb -user infodba -password infodba -database tc Unlike the list_users TC command, this will give a count of logged in users. Grab a count of currently logged in users I also created a cmdlet called Get-UserCount that grabs how many users are logged into the environment. Get-UserList –datasource –user –password –databaseįill in the correct values for this in your environment, and you’ll get an output that looks like this: It also formats it to look real pretty when you run the command. What does the cmdlet do? It grabs the logged in user and the date/time they logged in. #close the DB connection (very important!) $connection.ConnectionString = $connectionString $query = "SELECT puser_name, plogin_date FROM dbo.PPOM_SESSION" #write the query and save it as a variable $connectionString = "Server=$datasource uid=$user pwd=$password Database=$database Integrated Security=False " HelpMessage="Enter Teamcenter Database to connect to. HelpMessage="Enter Database User, not application or domain username." For example, this is used to log in to SSMS. HelpMessage="Enter the name of the Teamcenter Database server")] # Name of the Teamcenter Database server where the database is stored [CmdletBinding(SupportsShouldProcess=$true, Lo and behold the date/time is right there in the table. I found the table where this information was stored. I started by navigating the database in SQL Server Management Studio (SSMS).
Siemens teamcenter clear cache code#
This is the first issue I tackled, and you’ll be able to see from the code in the cmdlet that it opened the door for me to solve the other issues. Problem 1: List_users does not show me the date/time a user logged in Let’s roll through these problems and I’ll show my solutions: Problem 4: How can I tell which user is using which syslog?
![siemens teamcenter clear cache siemens teamcenter clear cache](https://saratech.com/wp-content/uploads/2020/11/blog_thumbnail_graphic_editing_and_creating_rac_awc_stylesheets.jpg)
Problem 3: I need to clear the cache on a remote machine. Problem 2: How many author licenses are we consuming? What about consumer licenses? Problem 1: When did this user log into Teamcenter? Which of these sessions in list_users is the session that is stale?
![siemens teamcenter clear cache siemens teamcenter clear cache](http://www.teamcenter-helpdesk.com/wp-content/uploads/2021/06/Snag_1f5c7a77.png)
Here is a list of the admin problems I was experiencing:
Siemens teamcenter clear cache full#
Luckily, the internet is FULL of information about PowerShell! It didn’t take long for me to start creating my own scripts and eventually start creating cmdlets. I had to do my due diligence to find out.
![siemens teamcenter clear cache siemens teamcenter clear cache](https://www.plm.automation.siemens.com/media/global/en/teamcenter_eclass_640x360_tcm27-53038.jpg)
I didn’t even know if it was the right tool for the job.
Siemens teamcenter clear cache how to#
I didn’t have a lot of experience with Powershell, or even really know how to use it. Once again, I was caught up in the emptiness of information available on the internet for Teamcenter. I had several problems to solve and I wasn’t sure how to solve them. I’ve created a handful of tools within Powershell to help alleviate the problem. I’ve found that the admin features available to us on Windows can leave a lot to be desired. The Windows-centric Teamcenter admin can feel quite isolated at times.