Trying to create a report and need to know if something is possible.

Comments

1 comment

  • Adam Ruth

    Kyle,

    Good question.  This can be done with an SQL report, but it can get a bit complicated.  There are a couple of ways to do it, here's an example that uses a sub-query for each application column.

    select
    Computers.Name as "Computer Name",
    Computers.Description,
    (select Version from Applications where ComputerId = Computers.ComputerId and Name = 'Dropbox' collate nocase) as "Dropbox Version",
    (select Version from Applications where ComputerId = Computers.ComputerId and Name = 'iTunes' collate nocase) as "iTunes Version"
    from Computers
    where <ComputerFilter>

    You would need to add a new column for each application and set the filter and column name.

    Hard drive size can be done similarly, though it will depend a bit on exactly what you want to see.  You could add a column like this:

    (select sum(Size)/1024/1024/1024 from DiskDrives where ComputerId = Computers.ComputerId) as "Disk Size"

    This will give you the total size of all disks in GB.

    0
    Comment actions Permalink

Please sign in to leave a comment.