Register Now

Continue with LinkedIn
Continue with Facebook
Continue with Google
Continue with Twitter

Login


Continue with LinkedIn
Continue with Facebook
Continue with Google
Continue with Twitter

Forget

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

x

Login


Continue with LinkedIn
Continue with Facebook
Continue with Google
Continue with Twitter

Forget

Register Now

Create an account
x
  • Home
  • SCCM
  • Intune
  • OSD
  • Autopilot
  • AVD
  • Windows 11
  • Windows 10
  • Jobs
  • Microsoft Tech Jobs

Login


Continue with LinkedIn
Continue with Facebook
Continue with Google
Continue with Twitter

Forget

Register Now

Create an account
HTMD Forum HTMD Forum
  • Home
  • SCCM
  • Intune
  • OSD
  • Autopilot
  • AVD
  • Windows 11
  • Windows 10
  • Jobs
  • Microsoft Tech Jobs

sql query

Home/ sql query

SQL Query Data Missing OperatingSystem0

Question
Deepak Rai Deepak Rai
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 7 months 4 Answers 31 views Admin

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

Question
Deepak Rai Deepak Rai
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 1 year 3 Answers 246 views Admin

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

Question
Saurabh Sharma Saurabh Sharma
Require SQL query for application version installed on user device along with device name
solved 0
Configuration Manager 2 years 2 Answers 233 views Beginner

Query to find the whole patch process time

Question
raj ddd raj ddd
Need a query to find all the process happened during patching with time. Eg past due,downloading updates,installing,pending reboot,installed... Any help
in progress 0
Configuration Manager 2 years 1 Answer 142 views Beginner

Ms Visio MS Project Custom Report

Question
Saurabh Sharma Saurabh Sharma
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 2 years 7 Answers 245 views Beginner

No. of packages requested from DP’s

Question
Srishti Sinha Srishti Sinha
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 3 years 3 Answers 118 views Beginner
© 2020 | How To Manage Devices