Reports & Analytics

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! Need a report for all 52 inch monitor that i have with model and compagny name

Is there a way of creating a reporte of all 52 inch monitor includin S/N, model number, manifacture and computer that it attache to.Thank you all.Dan

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

Resolved! Monitor SCCM 2012 Client

I have added a custom scan to see what version of the SCCM2012 Client is installed.(It checks for the file %windir%\CCM\SCClient.exe)A second custom scan checks for registry HKLM\SOFTWARE\Microsoft\CCM" value "SMSSLP" to see which site it uses.Can yo...

Resolved! Custom Report Missing Some Records

I have a simple asset report whose only criteria is that custom field #5 (defined as a radio button list) contains one of six possible team member names. It is supposed to be listing those assets that were physically inventoried by one of the six tea...