sql query

Hello All, Happy New Year! I need some help to create a SQL query for system that has this KB890830 which is Microsoft Malicious Removal Tool. It is only showing in the Other Updates in Update History for windows 11 systems. I can search the system and it is a .exe file which is mrt.ext in...

hi! I'm writing because I have a question. I created a Device collection query like this: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join...

Hello, I need sql query I'm tring write and looking internet coudn't find. Who is help me this situation. I need dedicated report, Collection name, {ublisher, Soft name, version, hostname, username, install date, last usage date and install count

Hello, I largely tried to avoid user-based deployments in favor of device-based deployments, but I am trying to get the deployment status of an application that is deployed to a user-based collection. I worked with the below code to try to get results from a user-based deployment, but no...

HI All, is there any SQL query for fetching the Windows update compliance report for all systems.

Guys, I'm looking for a SCCM SSRS Report to know the status (installed or not) of a specific software/application on a specific collection. Do you know about this? I have this .rdl as base (SSRS 2012). Remember to change the dataset. https://1drv.ms/u/s!ApU3gCm4YRBIhN12OGV1U0sLofQZsg...

Hi, I am looking for a sql query that lists the application installed (with version) from list of all computers in my organization. I am configuration manager and I know how to run the query from management studio. I just need the query. please help.