Get Started with Lansweeper Over 400 Built-in Network Reports AvailableĬhoose from over 400 Ready-Made Network Reports or Build Custom Reports within Minutes. Note: User logons are only scanned if the user is. You just need to add this field to your report. web50repwinuserlogonlast.Username) 1 Then tblassets.AssetName. Andy.S wrote: This should give you a starting point, this lists each asset and the Users Last logged on : Select Top 1000000 Case When RowNumber() Over (Partition By tblassets.AssetName Order By web50repwinuserlogonlast.Username) 1 Then tblassets.AssetName Else Null End As Asse. The last scanned user is always stored in ername. When RowNumber () Over (Partition By tblassets.AssetName Order By. Make Informed Decisions & Be Audit Ready at Any Time Andy.S wrote: This should give you a starting point, this lists each asset and the Users Last logged on : Select Top 1000000 Case. Instead if going through your assets one by one, your report results show you a neat overview of, for example, all assets that are out of warranty, printers that are about to run out of toner, or unauthorized administrators on your computers. Reports gather specific information based on criteria in a convenient overview. The most versatile one is without a doubt the use of reports. ![]() Lansweeper offers many different methods to organize your scanned data into categories which are useful and relevant to you. The combination of dashboards and IT reports provide the best of both worlds, easy to analyze and unlimited depth when needed. Browse our Report Library. Utilize custom reports provided by Lansweeper or other customers to gain further insights into patch status, vulnerability exposure, security compliance and more. Use the combination of dashboard and detailed reports to gain complete insight into your IT environment. Utilize the IT dashboards to get the most important information quickly and never be out of the loop again. Instead of navigating to multiple pages, individually comparing results or data, compare or analyze the data in one simple overview. Use a wide range of widgets for charts, overviews, data reports and more to create your perfect dashboard. Create dashboards for specific use cases like hardware, software, security, vulnerabilities and more. Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tblAssets.Lastseen, tblAssets.Lasttried, Max(tblCPlogoninfo. Visualize and analyze all the gathered data easily by using the IT dashboards and widgets. Run the report below and replace 30 with any time frame you would like to report on. Gain unprecedented insights into your environment Visualize Your Data TblAssetCustom.Manufacturer Like '%vmware%' And tblOperatingsystem.IT Analytics Leverage complete visibility and Where SubQuery.LastLogon >= GetDate() - 90) And ![]() TblAssets.AssetID = tblCPlogoninfo.AssetID TblCPlogoninfo.logontime = SubQuery.LastLogon Inner Join tblAssets On ![]() SubQuery.Username And tblCPlogoninfo.Domain = SubQuery.Domain And ![]() TblCPlogoninfo.Domain) SubQuery On tblCPlogoninfo.Username = Max(tblCPlogoninfo.logontime) As LastLogon Where tblAssets.AssetID Not In (Select Top 1000000 tblAssets.AssetIDįrom tblCPlogoninfo Inner Join (Select Top 1000000 tblCPlogoninfo.Username, Inner Join tblADusers On tblADObjects.ADObjectID = tblADusers.ADObjectID Inner Join tblADObjects On tblADComputers.ManagerADObjectId = Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID TblAssets.AssetID = tblOperatingsystem.AssetID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Looking for assistance creating a report that will provide a list of VMs that no one has logged into for at least 90 days, created the below report but does not seem to coincide with the logon times as I see VMs in the list that were recently logged into:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |