Hello,
I ran a query "select name from V_GROUPS" in SQL server and exported the group names to compare it with the SEPM. However, Both are not matching. SQL result consist of old groups which is not existing in the SEPM now. Is this something shows that the Database contains old entries of the SEPM.
What's the exact SEPM version here?
It is 12.1 RU3
This view contains the whole lot. If you want to see only the groups that currently exist, you'll need to filter out the records that have DELETED = 1 (this is the last column if you look at it from SQL Management Studio).
Here you go, this should do it:
SELECT TOP 1000 [ID] ,[NAME] ,[TYPE] ,[DOMAIN_ID] ,[DELETED] FROM [sem5].[dbo].[V_GROUPS] where [DELETED] is null
Note: I'm not a DBA, so there may well be a better way of doing this!
Thank you very much for your query. This is the query I needed. Is it possible to execute a query or generate a report in SEPM to find the un-used groups. I don think there is a report to find this.
I know there's a Computer Status report in the SEPM that shows the number of clients per group, but I'm not aware of any way to filter this to just those that have 0 clients (nor are my t-sql skills quite up to the task )
Is it possible to identify the same in the SEPM reports
Like I said, there's a Computer Status report on the SEPM, but it doesn't allow filtering to just those with 0 clients.
The report itself is called Client Count by Group if you want to have a look at it
This also helps. Thank you very much