Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
If you want to have references to ivanti Heat Incidents within Reports the following code should help, I have used Custom1 Field for the Incident Number, helpful if you log calls, for faults, upgrades etc 'http://HEAT-SERVER/Login.aspx?Provi...
Hi all,I need a report that will have pc model, manufacturer, operating system, memory and total size of HDD.I can create the report except getting the total HDD size (i can get it by partition). Is there a solution for this?Regards,
I decided to analyze AD users for administrative rights on local machines and wrote this query with 3 levels membership: Select Top 1000000 tblassets.AssetID, tblassets.Domain, tblassets.AssetName, tblUsersInGroup.Groupname As local_adm_group_n...
The SQL query has a command "Try_convert" in it. This is an invalid command. Revised code below. Select Distinct Top 1000000 Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain,...
Building a Purchasing system in Lansweeper.Using the ticketing system in HelpdeskThis is a six-part setup to create a Spiceworks-like experience in Lansweeper using the helpdesk ticketing system. Parts 1-4 are required. Part 5 is optional, but recomm...
I found interesting issue - when you have removed virtual machines from Hyper-V or vSphere then their assets are still exist.So I have created report for such assets: Select Top 1000000 tsysScannedBy.Description, tblIndirectScan.LastChanged as [Las...
I have created some chart reports.Source of data is https://learn.microsoft.com/en-us/windows/release-health/release-informationSee code of report for Windows 10 in this message: #M1190See code of report for Windows Server in this message: #M1189
Since June, I have noticed a flaw in the Patch Tuesday reports, showing red/OutOfDate when the Assets are indeed updated. After digging into several tables and comparing OS version numbers and KB releases, I have found a fix for July 2024. by adding...
