I am running the following report, however, I am missing computers, the built in Asset report detects it, I think the common denominator is no user logged onSelect Top 1000000 tsysOS.Image As icon, tblAssetCustom.AssetID, tblAssets.AssetName, tblA...
Hi guys, struggling with this one. I'm putting together a report for Windows 10 Feature Updates and I want to pull the last feature update error event log only. Can anyone help? This is my report:Select Top 1000000 tsysOS.Image As icon, tblAssets.As...
Hi all, any help appreciated. I am looking to run a report to find any device that DOES NOT have a particular version of software installed - Software is: Check Point Endpoint Security: Version 80.82.4063... I would like the below fields incl...
I have problem with create/edit reports in Report Builder. The reports work fine with presenting the result, but when I want to edit a report the Report Builder doesn't show anything. The same if I want to create a new report. See the image below.I h...
I am new to this but I can't seem to find a way to do this.Wondering if there is a way to add a column showing whether or not an asset has a TPM chip?I also need to add the OS column but I think I can get that.Thanks!Select Top 1000000 tsysAssetTypes...
Hi All I have an asset report for all domain machines.Part of the report is to show the graphic card(s).Some machines are listed as having 2 cards. Therefore the same machine gets listed twice in the report.The first time with Graphics card A, the se...
Hi AllI have an asset report that works fairly wellI'm attempting to exclude all servers - mostly VMs and an HP The 'models' that show that i would like to exclude is 'VMware Virtual Platform' + 'ProLiant DL380 Gen9'Thanks in advance for any assista...