How to map installed SW to Machine name or IP adrdess. RRS feed

  • Question

  • How can one find out form the automatically generated reports which machine has particular software installed. For example I have downloaded the Windows Environment Summary Report which shows that for example I have 6 copies Visio installed but it doesn't tell me on which machine.

    Would I need to create a cuctom report and how.

    Thank you

    Tuesday, October 7, 2014 6:04 PM

All replies

  • Try using the steps outlined in this blog:

    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. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.

    Wednesday, October 15, 2014 7:25 PM
  • Thank you Michael!! Our DBA has also put this script together which is useful.


    cid.ComputerSystemName AS MachineName
        , cid.UserName
    , cid.Organization AS OrganizationalUnit
    , CONVERT(varchar(200), cid.AdDatetime) AS [LastHWScanDate]
    , CONVERT(varchar(200), cid.AdDatetime) AS [LastSWScanDate]
    --, GETDATE () AS [Last SW Scan]
    --, LastSWScanDate
    , CASE WHEN OsFamilyName Like '%Server%' THEN 'Server' ELSE 'WORKSTATION' END AS [Type]
    , dahc.OsFamilyName AS [OSName]
    , prod.Name AS App
    , prod.Vendor AS Vendor
    , prod.Version
    --, CONVERT(varchar(200), prod.InstallDate) AS DateInstalled
    , pro.Name AS [ProcessorName]
    , dah.NumberOfProcessors
    , dah.NumberOfLogicalProcessors
    , dah.NumberOfCores
    , IPtab.IPAddress
    --, cid.DeviceNumber AS AssetTag
    , csp.Vendor AS [Manufacturer]
    , dah.ComputerModel
    , cid.SerialNumber
    , cid.AdDomainName AS DomainName
    , cid.BiosManufacturer AS BIOSManufacturer
    , cid.BiosName AS BIOSDescription
    , cid.BiosVersion AS BIOSVersion
    , CONVERT(varchar(200), cid.BiosReleaseDate) AS BIOSDate
    , cid.BiosSerialNumber AS BIOSSerialNumber

    FROM         Core_Inventory.Devices AS [cid] 

    INNER JOIN AllDevices_Assessment.HardwareInventoryEx dah ON cid.DeviceNumber = dah.DeviceNumber
    INNER JOIN AllDevices_Assessment.HardwareInventoryCore dahc ON cid.DeviceNumber = dahc.DeviceNumber 
    INNER JOIN Win_Inventory.Processors pro ON cid.DeviceNumber = pro.DeviceNumber
    INNER JOIN Win_Inventory.Products prod ON cid.DeviceNumber = prod.DeviceNumber
    INNER JOIN AllDevices_Assessment.CategorizedDevices acd ON cid.DeviceNumber = acd.DeviceNumber
    INNER JOIN [Win_Inventory].[ComputerSystemProduct] csp ON cid.DeviceNumber = csp.DeviceNumber

    , MAX(wip.IPAddress) AS IPAddress

    Win_Inventory.NetworkAdapterConfigurations wip

    wip.DeviceNumber) IPtab ON dah.DeviceNumber = IPtab.DeviceNumber

    WHERE LIKE '%Microsoft%'
    --AND NOT LIKE '%.NET Framework%'
    --AND NOT LIKE '%Visual C++%'
    --AND NOT LIKE '%Silverlight%'

    ORDER BY cid.ComputerSystemName

    Thursday, October 16, 2014 8:23 AM
  • Hi Lazo,

    Query you have is good but it would be missing editions of some pretty important software titles like SQL, Exchange, etc.

    If using the suggested link please be careful as we noticed that 'Product Editions' reported are often not correct. Take SQL for example, we found this view to report editions of a certain SQL instances as Enterprise but the same MAP tool and it's SQL report from the 'SQL Server Discovery' section would have Standard indicated.

    We confirmed that the SQL report was correct and the 'Product Edition' in this view was invalid.


    Thursday, November 6, 2014 7:54 PM