Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
I have about 1000 PCs im trying to report on. In Custom Field 1 ive renamed it to EOL (End of Life) in Date format. The point of this is for me to build a report to determine which PCs I need to replace each month. Could someone assist in helping me ...
I'm looking to create a report that runs daily for all the event logs for the workstations and servers in the domain. SQL is not something that I work with to often so I'm having some difficulty knowing exactly what it is I'm doing. However I was abl...
Hi LS teamI am wondering if you could modify my script as to prevent duplicate entries of the asset?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tsysOS.OSname, tsysOS.Image As icon, tblAssetCustom.Model, tsysIPLocations.IPLocatio...
We are trying to figure out how to detect Visual Studio 2017 editions. Lansweeper only detect the software installed as “Visual Studio 2017”. Prior versions are showing the editions but not in 2017 anymore. Any thoughts? Thanks.
HelloMy company have over 3000 assets and several Sites/IPLocations. Due the end of support of Windows 7 for 2020 wants to migrate to Windows 10 and would be super handly have report with a count of Windows 7, Windows 10 by IP Location. This way we ...
Want report of each asset a user has logged onto.Here is the report I have so far, based on an existing report, just only want to list an asset once instead of everytime user logged on. Right now I export into Excel and run Pivot table.Select Top 10...
Hey Guys, i've created an Asset Type in the Asset Management to do Asset Mapping for my Windows and Linux Servers. Also i have created Assets which are childs of the Asset Type. For Example the Name of my Asset Type is : Datacenter ...
Hi guys, I have the query below to get the logon history for each user, the problem is that the report is too large, is there a way to restrict on showing only the last 5 logins per user? With some users I'm getting up to 20 logins and we have more t...
