sql query

Question 1

SQL Query Data Missing OperatingSystem0

Question

Hello HTMDians, I am back with a new issue. I am trying to create one report which will have the hostname and operating system information. Till here everything seems fine. When i go to SQL and try to fetch select operatingsystem0 from ...

in progress 0

Configuration Manager 5 years 4 Answers 78 views Admin

Question 2

SQL Query for collection creation date, deployment name and enforcement state of endpoints

Question

Hello HTMDians, Help needed from all SQL Guru's in our forum. I have been trying to write one SQL Query where i need to fetch the compliance of the collection along with the enforcement state of each servers inside the collection and ...

solved 0

Configuration Manager 5 years 3 Answers 764 views Admin

Question 3

Require SQL query for application version installed on user device along with device name

Question

Require SQL query for application version installed on user device along with device name

solved 0

Configuration Manager 6 years 2 Answers 375 views Beginner

Question 4

Query to find the whole patch process time

Question

Need a query to find all the process happened during patching with time. Eg past due,downloading updates,installing,pending reboot,installed... Any help

solved 0

Configuration Manager 6 years 1 Answer 152 views Beginner

Question 5

Ms Visio MS Project Custom Report

Question

Hi All, Is there any SQL query for add or remove Ms Visio and MS Project application with Last login detail of user that is locally installed on user device? SQL query

solved 0

Configuration Manager 6 years 7 Answers 361 views Beginner

Question 6

No. of packages requested from DP’s

Question

I want to pull a report that tells me how many applications/packages request came to DP for download in last 3 days. Please help.

solved 0

Configuration Manager 7 years 3 Answers 125 views Beginner

Register Now

Login

Lost Password

Login

Register Now

sql query

SQL Query Data Missing OperatingSystem0

SQL Query for collection creation date, deployment name and enforcement state of endpoints

Require SQL query for application version installed on user device along with device name

Query to find the whole patch process time

Ms Visio MS Project Custom Report

No. of packages requested from DP’s