This simple little SQL query will show you how to gather information from both the SMS database as well as the Client health database. This script assumes that the Client Health database resides in the SMS database on the same server and is offered merely as a starting point for you to develop your own SQL Queries.
Note: Change [Client Health] to the client health database name. You do not need to use the right and left brackets if the name does not have any spaces in it.
SQL Query:
Use SMS_XXX
Select
v_R_System.Name0,
[Client Health].dbo.ClientHealthResults.Classification
From v_R_System
Join [Client Health].dbo.ClientHealthResults
On v_R_System.ResourceID = [Client Health].dbo.ClientHealthResults.ResourceID
No Comments