We have different levels of service for our clients. I have different scopes defined based on the service agreement and have the machine groups assigned to each scope.
What I need to do is generate a weekly report that will show total agents per scope.
Not seeing this right now any input greatly appreciated.
There is a system view called dbo.vdb_Scopes_Machines. If you run that it will give you the list of scope and machine per line. It is possible to have several machines that are in several scopes depending on your setup. You can open that in excel and create a pivot table to give you the totals you are looking for.
The SQL command to run the view is:
Select * from dbo.vdb_Scopes_Machines