‎07-06-2021 10:35 AM
‎10-06-2021 03:59 AM
Old: When tblAssets.AssetID = freespace.AssetID Then 'Pass'
New: When tblAssets.AssetID = disksize.AssetID Then 'Pass'
Old: End As [Disk space > 64GB],
New: End As [Disk size > 64GB],
Old: freespace.AssetID Then '#d4f4be'
New: disksize.AssetID Then '#d4f4be'
Old: Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As free,
New: Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As free,
Old: Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) > 64000) As freespace On freespace.AssetID = tblAssets.AssetID
New: Where Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) > 64000) As disksize On disksize.AssetID = tblAssets.AssetID
‎10-06-2021 03:48 AM
Line 484 | tblProcessor.name like '%Core%i7-7820HQ[1]%' or
Line 484 | tblProcessor.name like '%Core%i7-7820HQ%' or
‎07-08-2021 06:26 PM
‎07-08-2021 06:07 PM
‎07-08-2021 04:39 PM
‎08-30-2021 07:53 PM
doone128 wrote:
Would be great to see this report have a True/False column for machines that are determined compatible instead of just being colour coded. Makes it really easy to filter that way.
‎10-06-2021 10:23 AM
Mlaurin wrote:doone128 wrote:
Would be great to see this report have a True/False column for machines that are determined compatible instead of just being colour coded. Makes it really easy to filter that way.
It would help alot to have that to build a case!
threenub wrote:
Hi,
Just a small note that the statement below is incorrect and should not include the "[1]" part - which was for a footnote on the MS page.
Incorrect:
Line 484 | tblProcessor.name like '%Core%i7-7820HQ[1]%' or
Correct:
Line 484 | tblProcessor.name like '%Core%i7-7820HQ%' or
Cheers.
‎07-07-2021 04:53 PM
‎07-06-2021 10:18 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now