Search

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 9 months 4 Answers 32 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 1 year 3 Answers 277 views Admin

Question 3

SQL query

Question

Please help SQL query for distribution point role installed server name with OS version details.

solved 0

Configuration Manager 1 year 1 Answer 27 views Beginner

Question 4

SQL query

Question

Need SQL query to fetch machine information with country,department and department. Please help.

solved 0

Configuration Manager 1 year 4 Answers 26 views Beginner

Question 5

Required SQL query Registered SCCM Agent last 60 days

Question

Hi , Can some one please help , need to pull report registered SCCM agent last 60days Thanks

solved 0

Configuration Manager 1 year 2 Answers 52 views Beginner

Question 6

I need to create a sql query to find out bios details of a single machine, help me as i do not have any sql experience.

Question

i came across a script online now i want to know if i edit the machine name with the one i have will give me result of that particular machine or will it bring result of machine in my environment Select

solved 0

Configuration Manager 2 years 7 Answers 618 views Beginner

Question 7

SCCM 2006 : SCCM sql query to get clients on Metered Internet connection

Question

Experts, Do we have any SQL report available to know clients on metered internet connection. Actually, we are in plan of migrating from cisco VPN to Zscaler ZPA and observed that the sccm client activities like policy request, heartbeat DDR, h/w ...

solved 0

Configuration Manager 2 years 2 Answers 521 views Beginner

Question 8

Is there any SQL query that can fetch office365 installed on workstation along with version like 2011, 2016, 2015 in sccm

Question

Is there any SQL query that can fetch office365 installed on workstation along with version like 2011, 2016, 2015

solved 0

Configuration Manager 2 years 2 Answers 538 views Beginner

Question 9

SCCM Report or SQL Query to fetch the information of all SQL server versions & editions installed in environment

Question

Hello Guys, I am looking out for SCCM Report or SQL Query to fetch the information of all SQL server versions (2008, 2008R2, 2012, 2014 and so on) along with its editions (Enterprise, Standatd or Express)installed in environment. The report should ...

solved 1

Configuration Manager 2 years 2 Answers 1348 views Beginner

Question 10

SQL Query for SCCM

Question

hI, I need SQL query in sccm to get report of zoom client installed on client machines.

solved 1

Configuration Manager 2 years 1 Answer 309 views Beginner

Register Now

Login

Lost Password

Login

Register Now

Search

Search results for Sql query