→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
brandon_jones
Champion Sweeper III
The windows update settings built report is only listing 182 out of 800 computers. I copied the report from the built in reports forum and pasted it into my report and to see if maybe it has been edited, but I still only get 182 computers listed. Any ideas>
1 ACCEPTED SOLUTION
Denis_Sauneuf
Engaged Sweeper
There is a mistake in the code of this report.

You may create a new one with the code below:
(Menu report > create new report
Paste this code in the bottom area, and save and run.)

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblState.Statename,
tblAssets.Description,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tsysOS.OScode As Build,
tblAssets.SP,
tblAssets.Version,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case tblRegistry.Value
When '5' Then
'Automatic Updates is required, but end users can configure it'
When '4' Then 'Automatic download and scheduled installation'
When '3' Then 'Automatic download and notify of installation'
When '2' Then 'Notify before download'
When '1' Then 'Never check for updates'
Else 'Unknown, try rescanning the machine'
End As UpdateSettings
From tblAssets
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tblRegistry On tblRegistry.AssetID = tblAssets.AssetID and tblRegistry.Valuename = 'auoptions'
Where -- tblState.Statename = 'Active' And
tsysAssetTypes.AssetTypename In ('Windows', 'Windows CE')
Order By tblAssets.Domain,
tblAssets.AssetName


View solution in original post

2 REPLIES 2
brandon_jones
Champion Sweeper III
Thanks! That fixed it!
Denis_Sauneuf
Engaged Sweeper
There is a mistake in the code of this report.

You may create a new one with the code below:
(Menu report > create new report
Paste this code in the bottom area, and save and run.)

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblState.Statename,
tblAssets.Description,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tsysOS.OScode As Build,
tblAssets.SP,
tblAssets.Version,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case tblRegistry.Value
When '5' Then
'Automatic Updates is required, but end users can configure it'
When '4' Then 'Automatic download and scheduled installation'
When '3' Then 'Automatic download and notify of installation'
When '2' Then 'Notify before download'
When '1' Then 'Never check for updates'
Else 'Unknown, try rescanning the machine'
End As UpdateSettings
From tblAssets
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tblRegistry On tblRegistry.AssetID = tblAssets.AssetID and tblRegistry.Valuename = 'auoptions'
Where -- tblState.Statename = 'Active' And
tsysAssetTypes.AssetTypename In ('Windows', 'Windows CE')
Order By tblAssets.Domain,
tblAssets.AssetName