About moakyz03

moakyz03 · 12-24-2021

I've created this report and maybe someone else will find it useful - we need a "FullScanTime per asset" report. I created this report using multilevel subquery. Hopefully useful for those who need it.Select Top 1000000 SubQuery2.AssetID, SubQuery2....

moakyz03 · 02-22-2022

nateideal wrote:I'd like a report for both workstations and servers that shows those that have not installed any updates in over 90 days. Can anyone help me out? I tried modifying the Last Windows Update Audit report available but couldn't get it to ...

moakyz03 · 02-22-2022

simpler reports without multilevel subquerySelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.IPAddress, tsysIPLocations.IPLocation, tAssettype....

moakyz03 · 12-28-2021

Slightly modified "FullScanTime per asset" report by adding an asset type field.Select Top 1000000 SubQuery2.AssetID, SubQuery2.AssetName, SubQuery2.Domain, SubQuery2.IPAddress, SubQuery2.[Asset Type], SubQuery2.icon, SubQuery2.Scanserver, Sub...

moakyz03 · 12-24-2021

Hi, you can try this and see if it does what you need:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.IPAddress, tsysIPLocations.IPLocation, tAssettype.[Asset Type], tblAssets.Description, tblAssetCustom....

moakyz03 · 12-24-2021

Rich F wrote:Andy.S wrote:Computer AD Membership based on - https://www.lansweeper.com/forum/yaf_postst11019_Computers-no-in-AD-Group.aspx#post41158 :Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domai...

User Statistics

User Activity

Full Scan time per asset report

Re: 90 days Windows Update Audits

Re: Full Scan time per asset report

Re: Full Scan time per asset report

Re: Report to generate physical asset list

Re: Report listing computers found in specific OU group