Shulou(Shulou.com)06/02 Report--

There are only 4 days left in 2019. Looking back, I haven't written a blog this year.

Take advantage of the tail of 2019 to share the experience of this year's SCCM project. It is mainly about how to query SCCM-related report information through SQL statements.

Back to the point, by default after the installation of the report service, you can view the report data through the central management site in the sccm management console, but I feel that the report that comes with it is not easy to use, and the derived data format is not convenient to query the report directly through SQL.

Here are 10 commonly used SCCM statistical reports queried through the SQL statement:

1. System Discovery data

System_Disc report-View the data found by the SCCM system

two。 Computer IP address

2.1 System_IP_address_ARR report-View the IP address of all computers (including computers that do not have sccm clients installed)

Match according to ItemKey.

2.2 Network_Data reports-computers that need to be selected for IPEnabled00='1' (view only computers with SCCM clients installed)

3. Collection, computer detail report

3.1 CollectionMembers report-View member information in the collection

3.2 Collection_G report-View collection information

4.SCCM client active / active statu

V_CombinedDeviceResources view-view various status information of all devices, including computer last logged in user LastLogonUser, last active time LastActiveTime, whether obsolete (reinstalled) IsObsolete

SQL query the active computer statement within 90 days:

LastActiveTime > Dateadd (DAY,-90,GETDate ())

5. Computer hardware information-manufacturer, model, SN number

5.1 PC_BIOS_DATA report-View computer manufacturer, SN number, etc.

5.2 Computer_System_Data report-View computer manufacturer, model

6. The installed software of the computer

6.1 Installed_software_data reports-Statistics computer installed software

6.2 Installed_software_data_summary report-Statistics of the total number of software installations (ranking)

7. Computer operating system information

7.1 Computer_System_Data reports-Statistical computer system, Model, x86/x64, etc.

7.2 Operating_System_Data report-Statistics of operating system details, including installation path, installation time, operating system version, etc.

8. System console (login) user report

SYSTEM_CONSOLE-USER-DATA and SYSTEM_CONSOLE-USAGE-DATA reports-- check the current login, logged-in account and main login account information on the computer-- you need to enable audit and login through group policy in advance.

9. Software, package deployment status

V_ClassicDeplpymentAssestDetails view-view the deployment status of software and packages

10. Disk information

10.1 Partition_Data report-View computer disk Partition

10.2 LogicalDisk report-View logical disk information

The above reports are more commonly used in the daily work, and have a certain management role for the daily client operation and maintenance work.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.