Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

SQL Query to show the CMDB Dataclasses and assoicated SQL Tables

Created: 03 Apr 2014
WDRAIN1's picture
0 0 Votes
Login to vote

select distinct vi.name as [Data Class]

          ,dc.DataTableName as [SQL table]

          ,dc.MultiRow

           ,p.Name as Solution

           , p.Description

from ResourceUpdateSummary rs

-- dataclasses name

join vItem vi on vi.Guid = rs.InventoryClassGuid

-- solution table

join vProduct p on p.Guid = vi.ProductGuid

-- sql tables

join DataClass dc on dc.Guid = rs.InventoryClassGuid

order by p.Name, vi.Name

CMDB dataclassess.jpg