:::: MENU ::::

To find the AdvertID on which folder structure created in SCCM console

To find the AdvertID on which Folder structure created in SCCM console

 

SELECT     Folders.name AS [Advertisement Created Under(Folder Name)], Foldermembers.instancekey AS AdvertID,

V_advertisement.Advertisementname AS [Advertisement Name]

FROM         dbo.Folders INNER JOIN

dbo.FolderMembers ON Foldermembers.containernodeid = folders.containernodeid INNER JOIN

dbo.v_Advertisement ON V_advertisement.advertisementid = Foldermembers.instancekey

WHERE     (V_advertisement.advertisementid = ‘AdvertID’)


One Comment

So, what do you think ?