SMS 2003 - SQL Query - Patch Installed Report & Status

All replies

• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  Not Sure about Garth.

  ---

  Veera

  Tuesday, June 14, 2016 12:59 PM
• 

  

  0

  Sign in to vote

  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