check packages_SQL Queries

All Packages available in SCCM 2 Package Deployment Detailed status for specific Advertisement ID 2 All Packages Total Targeted DP Counts 2 All Packages Compare targeted Packages on Two DPS 4 Compare Packages with two DP’S 4 All Software Distribution Packages without...

site servers_SQL Queries

All PCs discovered from specific site 2 All PCs client assigned and installed site code details 2 All Site Servers Issue MP components status 2 All Site Servers Issue DP components status 2 All Site Servers Issue DDR components status 3 All Site Servers Issue CCR...

sccm basic check_SQL Queries

Find SQL Server Installed Version 1 Find SCCM SQL Database Size with Database File Path 1 Find Overall SCCM Site Hierarchy Information 1 Find SCCM Site Hierarchy Detailed Information 1 Find Overall Windows Workstations Client Machines OS category with counts 2 Find...

check applications_SQL Queries

All PCs with particular application last used date 2 All Software applications required deployments status within 30 days 2 All Software applications available deployments status within 30 days 3 All Software applications simulate deployments status within 30 days 3...

OSD_SQL Queries

All OSD required deployments status within 30 days 1 All OSD available deployments status within 30 days 1 All Operating systems deployments status 2 All Deployments status for Specific Task Sequence 3 All OSD required deployments status within 30 days Declare...

Hardware_software inventory_SQL Queries

All SQL Server Installed Version and Computer Details using Hardware Inventory 2 All IE Version using Software Inventory 2 All Active Workstations Client Hardware Inventory Status 2 All Active Servers Client Hardware Inventory Status 4 All Active Workstations Client...

SUP_SQL Queries

All Software updates required deployments status within 30 days 2 All Software updates available deployments status within 30 days 2 All SCCM Server Software Update Sync status 3 All Software updates required deployments status within 5 days 3 All Software updates...

Ensemble de Query SQL pour SCCM – Section client

All check SCCM client _ SQL queries All Client Settings Status 2 All Workstations Client Health Summary Status 2 All Servers Client Health Summary Status 2 All Active and Inactive Workstations Client Status 2 All Active and Inactive Servers Client Status 3 All Active...
error

Enjoy this blog? Please spread the word :)

RSS
Follow by Email
Facebook
Facebook
Twitter
Visit Us
LinkedIn