Symantec Management Platform (Notification Server)

Hello,

I jsut need some quick assitance in creating some reports linking the data from from two Altiris Databases on the same SQL server.

The query info I ma looking for are as follows

Altiris.odb <== First database

Inv_Aex_DS_Machine_Inventory <== Table
Asset Tag
Serial Number
Manufacturer
Model Number
Bios Version
UUID

Inv_AeX_HPCMS_WMI_Win32_DesktopMonitor <== Table
DeviceID
Name

Inv_Aex_HW_Monitor_spt <== Table
Serial Number


eXpress.odb <== second database

Computer <== Table
computer_name

computer_group <== Table
name

location <== Table
contact
phone

Unfortunately I'm not familiar with the exact structure & workings of the eXpress database for DS.

What you will more then likely have to do is to link the 2 databases together based of of the computer name, since DS probably has different identifiers for the computers. The Inv_Aex_DS_Machine_Inventory may contain the DS identifier

So something like the following.

SELECT vc.Name,  mi.[Asset Tag], mi.[Serial Number], mi.[Manufacture],mi.[Model Number], mi.[Bios Version], mi.UUID, dm.DeviceID, dm.Name,
     hwm.[Serial Number], c.Computer_Name, cg.Name AS 'Computer Group', l.contact, l.phone FROM vComputer vc
JOIN Inv_AeX_DS_Machine_Inventory mi ON mi._ResourceGuid = vc.Guid
JOIN Inv_AeX_HW_Monitor_spt m ON m._ResourceGuid = vc.Guid
JOIN Inv_AeX_HPCMS_WMI_Win32_DesktopMonitor dm ON dm._ResourceGuid = vc.Guid
JOIN [SQLSERVER].[eXpress.odb].dbo.Computer c ON c.Computer_Name = vc.Name
JOIN [SQLSERVER].[eXpress.odb].dbo.Computer_Group cg ON cg.identifier = c.identifier
JOIN [SQLSERVER].[eXpress.odb].dbo.Location l ON l.identifier = c.identifier


You will need to replace the [SQLSERVER] with the name of your actual sql server. You will also need to confirm which fields in the DS tables contain the unique ID for each computer so they can be properly linked.

HTH