‎05-26-2015 11:37 PM
Solved! Go to Solution.
‎05-29-2015 02:34 PM
Select tblAssets.AssetID,
tblAssets.AssetName,
Case When tblAssets.AssetID In (Select Top 1000000 tSoftware1.AssetID
From (Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%Photoshop%') tSoftware1
Inner Join (Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%Illustrator%') tSoftware2
On tSoftware1.AssetID = tSoftware2.AssetID Inner Join
(Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%InDesign%') tSoftware3
On tSoftware1.AssetID = tSoftware3.AssetID Inner Join
(Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%Bridge%') tSoftware4
On tSoftware1.AssetID = tSoftware4.AssetID Inner Join
(Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%Acrobat%') tSoftware5
On tSoftware1.AssetID = tSoftware5.AssetID) Then
'Creative Suite Design Standard' End As [Installed package]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
‎05-29-2015 02:34 PM
Select tblAssets.AssetID,
tblAssets.AssetName,
Case When tblAssets.AssetID In (Select Top 1000000 tSoftware1.AssetID
From (Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%Photoshop%') tSoftware1
Inner Join (Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%Illustrator%') tSoftware2
On tSoftware1.AssetID = tSoftware2.AssetID Inner Join
(Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%InDesign%') tSoftware3
On tSoftware1.AssetID = tSoftware3.AssetID Inner Join
(Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%Bridge%') tSoftware4
On tSoftware1.AssetID = tSoftware4.AssetID Inner Join
(Select tblMacApplications.AssetID
From tblSoftwareUni
Inner Join tblMacApplications On tblSoftwareUni.SoftID =
tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%Acrobat%') tSoftware5
On tSoftware1.AssetID = tSoftware5.AssetID) Then
'Creative Suite Design Standard' End As [Installed package]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now