Search

Question 1

SQL Query

Question

Hi All, Hi All, I'm trying to create a report that will give me the "Status", and "Error Description", I get from the Device Summary section in the "Assets Message" window under the "Details" tab for each system. I'm looking to get ...

in progress 0

Configuration Manager 3 weeks 1 Answer 42 views Beginner

Question 2

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 1 year 4 Answers 36 views Admin

Question 3

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 2 years 3 Answers 390 views Admin

Question 4

SQL query

Question

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

solved 0

Configuration Manager 2 years 1 Answer 28 views Beginner

Question 5

SQL query

Question

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

solved 0

Configuration Manager 2 years 4 Answers 27 views Beginner

Question 6

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 2 years 2 Answers 57 views Beginner

Question 7

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 774 views Beginner

Question 8

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 601 views Beginner

Question 9

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 673 views Beginner

Question 10

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 1605 views Beginner

Register Now

Login

Lost Password

Login

Register Now

Search

Search results for Sql query