Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

need SQL help with report showing various software

I have written a report to show our McAfee AntiVirus software modules and versions.I am having problems with the SQL coding. I want to show all computers that have any of the 4 softwares listed. My report currently shows only computers that have al...

amerisbank by Engaged Sweeper
  • 10525 Views
  • 3 replies
  • 0 kudos

Custom fields

I am wondering if I can import data into the database from another inventory system that we have been using. Is there a particular format and a way to do this?

progdlp by Engaged Sweeper
  • 9746 Views
  • 3 replies
  • 0 kudos

Database Design Documentation

Is there a document somewhere that describes in detail what all of the columns mean and how the tables are linked to each other? It would be most helpful in creating new reports. (Maybe this is part of the premium report writer?)

wgknowles by Engaged Sweeper II
  • 7995 Views
  • 1 replies
  • 0 kudos

Hardware Inventory

Hi all. Its possible (and some one could write it here), to make a report with a real inventory?ComputernameDomainProcessor speedMemoryHarddiskVGA ModelIPUsernameI dont know if its possible.

miauninja by Engaged Sweeper
  • 8697 Views
  • 2 replies
  • 0 kudos

relayed data from 2 different sql servers

Hi guys .. I have a query, I have a lansweeper data and attachments in dbo.tblCompCustom quero relayed to another sql server that is already taking data, but has no comments, bar codes and things like thatany idea?thanksvia google...

Tuxor by Engaged Sweeper
  • 6682 Views
  • 1 replies
  • 0 kudos

Report "No DVD drive" false positives

The built in report "No DVD drive" is either:1) Giving false positives when more then one optical drive is installed or 2) Not correctly detecting this particular DVD drive:Caption: HL-DT-ST DVD+-RW GSA-H21N Description: CD-ROM Drive DeviceID: ...

wgknowles by Engaged Sweeper II
  • 8263 Views
  • 2 replies
  • 0 kudos

Computername and description SQL script

Hello,As a starting SQL scripter I'm trying to get a report with:All computers which have 'SafeGuard Enterprise 5.30.0 Client' installed but not have 'SafeGuard Enterprise 5.35.2 Client ' installed. In the report i would like to have the computername...