hi,how would i perform a query which shows AD Users for a given year. I.E.Year - Users2014 - 15002015 - 16002016 - 16502017 - 1700Using the "Date Created" and "Last Scaned" to determin if a user was active at the time.
Hi, I have created this report. The report will give me PC owner based on "Owned by". But if there is no Owner of a PC then I will not see it in the report list, how can I change it so It also shows me the PC's without any owner?Select Top 1000000 tb...
Dear Lansweeper support teamIm here to report a problem about a Share permission section. When I scan it lansweeper shows me a dozens of active Everyone share folder, But when I check it properly some of them are not in Everyone Share settings. I do...
1st post. Sorry if this is a simple request, having trouble searching report center for this. Looking for a report or pointers on custom report to show all of my agents active time they spent on a ticket. Does something like this exist? Or can th...
I need a report with all SQL server and editions with service state.if i take the table tblService,tblServiceUni with Like SQL Server (% and tblServiceState i see in the report for all sql more then one state:Select Top 1000000 tsysOS.Image As icon, ...
Hello. I found a report to list mac addresses and added the portable battery and IPLocation at the request of managment to try and output all laptops asset name, domain, network card, mac addresses, ip, last changed, userID, IPlocation and got a goo...
I am trying to create a report that will show an asset that has had a state change within the past 24 hours. This report will be used to auto email the asset manager that an asset has changed, for example: we take an asset out of service to be recy...
