Resolved! Number of computers users are logging into
I am trying to find out who is logging into which machines, with a count of how many different machines that they log into, with a date and time they logged in.
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 am trying to find out who is logging into which machines, with a count of how many different machines that they log into, with a date and time they logged in.
I am trying to create a report of all services on a machine, then sort it by startup type and state. I have started but haven't been very successful.
Is there a way to create a report similar to the "All installed software" report where we can group by similar/like software names?For example, we would like to take this:Software..................................Version..Publisher...TotalJava 7 Upda...
Hello,I'm not the best with SQL or at all But I'm looking to create a report that will pull all information from Event Log for all serversI have this that looks for errors over 14 daysSelect Top 1000000 Convert(nVARCHAR(10),tblNtlog.TimeGenerated,102...
Greetings. I have an all asset report almost where I need it but I need a few tweaks that I can't figure out. I need the following items added to my report.On the monitors that are listed in this report I want them to tie back to the computer they ...
I have the following report:Select Top 1000000 SubQuery.Username, SubQuery.Domain As Userdomain, SubQuery.LastLogon, tblAssets.AssetName, tblADusers.DisplaynameFrom tblCPlogoninfo Inner Join (Select Top 1000000 tblCPlogoninfo.Username, tblCPl...
Hey guys,I know very very little about SQL.Could someone help me to get together a report which would give meall LCDs having an Asset relation "Connected To" to all computers in one of our IP Locations pls?BTW: 1) we have two subnets there 172.20.102...
I am trying to create a report which will allow me to run a Software license report for different departments. The built-in reports works well for ALL of the license and associated software but I need to have a different report for each department. I...
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try NowUser | Count |
---|---|
18 | |
13 | |
4 | |
1 | |
1 |