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.
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...
