‎03-10-2015 07:49 AM
Solved! Go to Solution.
‎03-10-2015 01:23 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case tAUOptions.Value When 2 Then 'notify before download'
When 3 Then 'automatically download and notify of installation'
When 4 Then 'automatic download and scheduled installation'
When 5 Then 'automatic updates is required, but end users can configure it'
Else 'unkown' End As [AU options],
Case tNoAutoUpdate.Value When 1 Then 'disable automatic updates'
When 0 Then 'enable automatic updates' Else 'unkown' End As [No auto-update]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'auoptions') tAUOptions
On tblAssets.AssetID = tAUOptions.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'noautoupdate') tNoAutoUpdate
On tblAssets.AssetID = tNoAutoUpdate.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
‎03-10-2015 01:39 PM
‎03-10-2015 01:23 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case tAUOptions.Value When 2 Then 'notify before download'
When 3 Then 'automatically download and notify of installation'
When 4 Then 'automatic download and scheduled installation'
When 5 Then 'automatic updates is required, but end users can configure it'
Else 'unkown' End As [AU options],
Case tNoAutoUpdate.Value When 1 Then 'disable automatic updates'
When 0 Then 'enable automatic updates' Else 'unkown' End As [No auto-update]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'auoptions') tAUOptions
On tblAssets.AssetID = tAUOptions.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename Like 'noautoupdate') tNoAutoUpdate
On tblAssets.AssetID = tNoAutoUpdate.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now