Video Screencast Help
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 as [Data Class]

          ,dc.DataTableName as [SQL table]


           ,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