|
Posted by Verve on 09/08/05 12:27
That's what my problem is. I have to query some different machine with
different administrator. I can give a list of the properties that I
need to retrieve. For the rest I have found WMI classes:
1. Replication
With which servers
Publisher/Subscripto
2. Memory allocation (Dynamic or fixed)
How much is allocated
3. Memory allocated to SQL query
4. Maximum Concurrent User Connections
5. Startup parameters
6. Enabled Protocols (Named Pipes, TCPIP etc...)
7. Backup Service enable and details
8. DB Maintenance Plans
9. Log info (Date, Size, DB)
10. SQL Logins
11. Only need to gather the SQL specific login accounts
12. Linked Servers
Navigation:
[Reply to this message]
|