Answered by:
SMS 2003 - SQL Query - Patch Installed Report & Status

Question
-
Dear Experts,
Requesting your support to create Custom SQL Query for the following scenario's
Scenario 1:
All Clients : 7 Days
Classification : Security Updates, Where Installed = No, Where Superseded = No, Where Expired = No, Where Approved = Yes.
I am trying to find the list of Updates which applied to the Work Station. Suggest me with SQL Queries on this pls.
Regards,
Veera
Veera
Monday, June 13, 2016 10:27 PM
Answers
-
Not Sure about Garth.
Veera
SMS 2003 is no longer support (1/13/2015) and therefore neither is ITMU. For that matter neither is SQL 2005 ( 4/12/2016).
Garth Jones
Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx
Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased
- Proposed as answer by Matthew Hudson [MVP]MVP Monday, June 20, 2016 8:17 PM
- Marked as answer by Garth JonesMVP Saturday, July 23, 2016 2:37 PM
Tuesday, June 14, 2016 1:48 PM
All replies
-
Dear Experts,
I am trying to build Custom report on SMS 2003 Environment using Existing SQL 2005. Please advice me the work flow to progress the same.
This Report Generate complete details as follows:
1. List of Machines - Which is having Active Client, Installed Updates - No, Superseded - No., Expired - No., Approved - Yes.
Likewise, need to create multiple reports on the same. Please suggest the support links for reference pls.
Regards,
Veera
Veera
- Merged by Garth JonesMVP Tuesday, June 14, 2016 12:35 PM Its the same Q.
Tuesday, June 14, 2016 12:13 PM -
This will not be simple as SMS 2003 use ITMU. I'm sure that the data is stored within the db but is ITMU even supported anymore? Check out my old blog for ITMU queries.
Garth Jones
Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx
Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased
Tuesday, June 14, 2016 12:32 PM -
Not Sure about Garth.
Veera
Tuesday, June 14, 2016 12:59 PM -
Not Sure about Garth.
Veera
SMS 2003 is no longer support (1/13/2015) and therefore neither is ITMU. For that matter neither is SQL 2005 ( 4/12/2016).
Garth Jones
Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx
Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased
- Proposed as answer by Matthew Hudson [MVP]MVP Monday, June 20, 2016 8:17 PM
- Marked as answer by Garth JonesMVP Saturday, July 23, 2016 2:37 PM
Tuesday, June 14, 2016 1:48 PM