Hello, is there a report where I can see the date that a machine updated its Windows version? For example, when it was updated from Windows 10 to Windows 11?
Dear,I would like to create a report with the status of a specific windows service, for example:service: servicexxx status: running or stop startmode: enable, disable
Is there a way to merge existing reports into a new one?We have reports for assets by environment\type (Azure, Windows, Linux, Physical servers, VM servers, VM Guest) but would like to have 1 master report showing all the information in the individua...
You amazing guys helped me with this report before.https://www.lansweeper.com/forum/yaf_postsm64039_Webcam-report--the-wrong-way.aspx#post64039I have modified and added to it somewhat since then and whenever I run it, it now duplicates a pc, with the...
good morning.I found these instructions for two separate reports, covering average CPU and RAM usage:CPU:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, Cast(Avg(tblPerformanceCountersScanMetric.Value) As int) As [Average CPU usage in %...
I am using the Virtual Guest Machines report copied from https://www.lansweeper.com/report/vmware-virtual-guest-machines/ I would like to add a field for the guest operating system if it is known but everything I've tried results in duplicate entries...
When I add tblADComputers.OU into a report, it prints the entire OU. Is there a way to have it only print the lowest level OU?Ex:Instead of printing `OU=WebServers,OU=Servers,OU=Computers,DC=EXAMPLE,DC=COM`Just print `OU=WebServers`Or even just `Web...
I have seen this asked several times but never with a clear answer. How do we get the root cause displayed in a Help Desk report?What I need is the built in report Helpdesk: All tickets that have been created but add a column for root cause.Bonus po...
I'm trying to find a report that will show me a list of all tickets that have been opened but not "picked up" yet. Any suggestions? I've tried this with no luck:Select Top 1000000 htblticket.ticketid As [Ticket Number], htblticket.date As [Date Op...
