September 2017
Intermediate to advanced
376 pages
8h 28m
English
Reports are also the queries to a database, but this time--unlike with WMI--the administrator is working on data from the SQL database. The SQL database contains data available in the WMI database as well as data related to the ConfigMgr server and the whole environment. Here is an example of a report showing the name of the operating system and the date of its installation:
SELECT v_R_System.Name0 AS [Machine Name], v_GS_OPERATING_SYSTEM.InstallDate0 AS [OS Deployed On] FROM v_GS_OPERATING_SYSTEM INNER JOIN v_R_System ON v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID
As has been mentioned before, you need to know certain things to create queries and reports. When creating a report, the administrator needs to find relevant ...
Read now
Unlock full access