Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
Can I find out the version of the installed OS & service pack

Answered Can I find out the version of the installed OS & service pack

  • Monday, June 18, 2012 7:16 PM
     
     
    Sign In to Vote
    0

    I have Microsoft Assessment and Planning Toolkit version 6.5.4229.01 installed and have exported the database  into SQL server for reporting.

    Is there a way for me to search the data collected in the tables and find out the version of the operating system and what service pack installed on them.

    I would like to avoid  visiting  the desktops connected to the network  and hoping that the collected data in the database allow me to identify the version of the OS and the service pack/patches  of the workstations, and to prepare a report  to  let the client know which one of their PC's need windows update, security patches & .. and which one's are up to date.

    Appreciate any suggestion/feedback.

    Thanks

    Jay

    Jay Tabatabai

     

All Replies

  • Tuesday, June 19, 2012 12:40 AM
     
     
    Sign In to Vote
    0

    Jay - Have you run an inventory from the MAP tool? That should give you the info you're looking for (i.e. OS and/or SP version).

    Pman
    http://www.pmansLab.com/

     
  • Tuesday, June 19, 2012 4:31 PM
     
     
    Sign In to Vote
    0

    Hi Parvez,

    I did run the inventory tool, but since there are no data dictionary available for the MAP (that I know of), I am not able to find the OS and/or SP version. I looked at few tables, i.e.   "Windows_Installed_Software_Full table", "Products"  .. but could not find any OS /patch info.

    Do you happen to know the table names (in the MAP database), that may have the data that I am looking for?

    Thanks

    Jay

    Jay Tabatabai

     
  • Wednesday, June 20, 2012 12:34 AM
    Moderator
     
     
    Sign In to Vote
    0
    The SQL Server Assessment report has all of this info in it. Just go to Databases > SQL Server and choose "Generate Report" in the Actions pane.

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

     
  • Wednesday, June 20, 2012 1:44 AM
     
     Answered
    Sign In to Vote
    0

    You can generate report from the MAP tool as Michael mentioned. You can also view the result of the inventory from the MAP tool. From the "Inventory and Assessment" toolpane on the left side, just select/expand "Desktop". From there you should be able to see the inventory result. You can sort/group the data differently too.

    I didn't have to export the entire database as of yet. So far the tool gives me the info I need.

    Pman
    http://www.pmansLab.com/

    • Marked As Answer by jaytaba Friday, June 22, 2012 6:27 AM
    •