Reports & Analytics

Resolved! How to add more fields to tblADusers

Hello !I need create a report with the extensionAttribute1 field from the Active Directory. I found a post about how to achieve it, seems like actually it's not scanned by default, but I'm not sure about the steps.What I understood is go to "Configur...

Resolved! Searching for Specific and Details Software Asset Reporting

Hi,I searching for a Special Report with following criterias:Dont know it is possible, Device Name AD UserDomain/Workgroups First Seen Last Time active MACIPOEM SerialVirtual / Physical Operating SYSOperating SYS Language Software 01 = Office Suite I...

Resolved! List Server with IP/Subnet/DNS Servers

I am looking for a report that will show me my servers along with their IP, Subnet and DNS servers used.

Resolved! Subqueries

I am trying to add a Microsoft Office Version column where it displays the Software Name as the results but im stuck.here is the subquery: Case When tblAssets.AssetID In (Select tblSoftware.AssetID From tblSoftware Inner Join tblSoftwareUni On tb...

Resolved! Custom Scanning Reports with Registry and Files values

Close but my newbie sql is not quite there ....I am trying to create a report that pulls from the Custom Scanning Tables, for both the files and registry information. Criteria is that a registry key is not found ( tblRegistry ) and a file is install...

Resolved! Number Computer logon's per day

Is it possible to get a report showing the number of workstations that have logged on that day?I know per asset, under the user info section there is a "logon time" I would be looking to total up all these for each of the last 7 days?Would it be poss...

Resolved! Asset uptime montly report with login hours

Resolved! Report to show USB mass storage devices

I would like to have a report that would list all computers and servers that have a USB mass storage device connected. I have tried tweaking a built-in report but I didnt get the results I wanted and I know very little about databases. Does anyone ha...