locked
MAP Database to Application Mapping RRS feed

  • General discussion

  • Experts,

    Can MS MAP(Microsoft Assessment and Planning ) tool be used to extract database to application mapping information for an environment.

    If yes, would it be able to extract info for MS Applications only or all the applications.

    Thanks

    Thursday, March 26, 2015 4:40 PM

All replies

  • Hi, 

    the MAP is possible to collect information from other software besides MS, for this you must install the SQL Management Studio, Connect the MAP Database "(localdb) \ maptoolkit" and execute the query.

    Do not forget to mark as resolved

    SELECT AllDevices_Assessment.HardwareInventoryCore.ComputerName,Win_Assessment.WindowsInstalledSoftwareFull.Name,Win_Assessment.WindowsInstalledSoftwareFull.Version,Win_Assessment.WindowsInstalledSoftwareFull.InstallLocation
    from AllDevices_Assessment.HardwareInventoryCore
    INNER JOIN Win_Assessment.WindowsInstalledSoftwareFull on (Win_Assessment.WindowsInstalledSoftwareFull.DeviceNumber = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber)
    WHERE Name LIKE '%%'
    AND Name NOT LIKE '%Flash%'
    AND Name Not Like '%Reader%'
    ORder by ComputerName

    Virtual Machines 

    select AllVirt_Assessment.VirtualizationAssessment.ComputerName,AllVirt_Assessment.VirtualizationAssessment.VmachineType,AllVirt_Assessment.VirtualizationAssessment.VmTechnology,AllVirt_Assessment.VirtualizationAssessment.MachineStatus,HyperV_Inventory.HostGuestDetails.GuestName,Win_Inventory.Processors.NumberOfCores, Win_Inventory.Processors.NumberOfLogicalProcessors,Win_Inventory.ComputerSystemProduct.Name,ISNULL(AllDevices_Assessment.CategorizedDevices.IsVirtual,0) AS IsVirtual
    from AllVirt_Assessment.VirtualizationAssessment
    inner join AllDevices_Assessment.HardwareInventoryCore on AllDevices_Assessment.HardwareInventoryCore.DeviceNumber = AllVirt_Assessment.VirtualizationAssessment.DeviceNumber
    inner join HyperV_Inventory.HostGuestDetails on HyperV_Inventory.HostGuestDetails.DeviceNumber = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber
    inner join Win_Inventory.Processors on Win_Inventory.Processors.DeviceNumber = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber
    inner join Win_Inventory.ComputerSystemProduct on Win_Inventory.ComputerSystemProduct.DeviceNumber = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber
    inner join AllDevices_Assessment.CategorizedDevices on AllDevices_Assessment.CategorizedDevices.DeviceNumber = Win_Inventory.ComputerSystemProduct.DeviceNumber

    Printer

    Select AllDevices_Assessment.HardwareInventoryCore.ComputerName,[Unused].[Printers].DeviceId
    from AllDevices_Assessment.HardwareInventoryCore
    inner join Win_Inventory.NetworkAdapterConfigurations on Win_Inventory.NetworkAdapterConfigurations.DeviceNumber = [Win_Inventory].[NetworkAdapterConfigurations].DeviceNumber
    inner join Unused.Printers on (Unused.Printers.DeviceNumber) = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber 
    where [Unused].[Printers].DeviceId like 'HP%' or [Unused].[Printers].DeviceId  like 'EPSON%';


    Lucas Simoes Rezende MCP, MCTS , ITIL V3

    Thursday, April 2, 2015 2:25 PM
  • Hi, 

    the MAP is possible to collect information from other software besides MS, for this you must install the SQL Management Studio, Connect the MAP Database "(localdb) \ maptoolkit" and execute the query.

    Do not forget to mark as resolved

    SELECT AllDevices_Assessment.HardwareInventoryCore.ComputerName,Win_Assessment.WindowsInstalledSoftwareFull.Name,Win_Assessment.WindowsInstalledSoftwareFull.Version,Win_Assessment.WindowsInstalledSoftwareFull.InstallLocation
    from AllDevices_Assessment.HardwareInventoryCore
    INNER JOIN Win_Assessment.WindowsInstalledSoftwareFull on (Win_Assessment.WindowsInstalledSoftwareFull.DeviceNumber = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber)
    WHERE Name LIKE '%%'
    AND Name NOT LIKE '%Flash%'
    AND Name Not Like '%Reader%'
    ORder by ComputerName

    Virtual Machines 

    select AllVirt_Assessment.VirtualizationAssessment.ComputerName,AllVirt_Assessment.VirtualizationAssessment.VmachineType,AllVirt_Assessment.VirtualizationAssessment.VmTechnology,AllVirt_Assessment.VirtualizationAssessment.MachineStatus,HyperV_Inventory.HostGuestDetails.GuestName,Win_Inventory.Processors.NumberOfCores, Win_Inventory.Processors.NumberOfLogicalProcessors,Win_Inventory.ComputerSystemProduct.Name,ISNULL(AllDevices_Assessment.CategorizedDevices.IsVirtual,0) AS IsVirtual
    from AllVirt_Assessment.VirtualizationAssessment
    inner join AllDevices_Assessment.HardwareInventoryCore on AllDevices_Assessment.HardwareInventoryCore.DeviceNumber = AllVirt_Assessment.VirtualizationAssessment.DeviceNumber
    inner join HyperV_Inventory.HostGuestDetails on HyperV_Inventory.HostGuestDetails.DeviceNumber = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber
    inner join Win_Inventory.Processors on Win_Inventory.Processors.DeviceNumber = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber
    inner join Win_Inventory.ComputerSystemProduct on Win_Inventory.ComputerSystemProduct.DeviceNumber = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber
    inner join AllDevices_Assessment.CategorizedDevices on AllDevices_Assessment.CategorizedDevices.DeviceNumber = Win_Inventory.ComputerSystemProduct.DeviceNumber

    Printer

    Select AllDevices_Assessment.HardwareInventoryCore.ComputerName,[Unused].[Printers].DeviceId
    from AllDevices_Assessment.HardwareInventoryCore
    inner join Win_Inventory.NetworkAdapterConfigurations on Win_Inventory.NetworkAdapterConfigurations.DeviceNumber = [Win_Inventory].[NetworkAdapterConfigurations].DeviceNumber
    inner join Unused.Printers on (Unused.Printers.DeviceNumber) = AllDevices_Assessment.HardwareInventoryCore.DeviceNumber 
    where [Unused].[Printers].DeviceId like 'HP%' or [Unused].[Printers].DeviceId  like 'EPSON%';

    Lucas Simoes Rezende MCP, MCTS , ITIL V3

    Thursday, April 2, 2015 2:33 PM
  • Thanks a lot Lucas , it is quite helpful.

    However not very sure how to mark it as resolved.

    Thursday, April 2, 2015 3:59 PM
  • Hi Lucas,

    What about PaaS Readiness web application mapping with database ??



    Friday, April 8, 2016 9:49 AM