Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Help building a custom report (WinXP SP2 systems with 1GB+ Free Space)

Created: 16 Apr 2012 | 3 comments

Good morning everyone.  I am currently working on a filter in our NS 7.1 to show systems that are running Windows XP SP2 and that have 1GB of free hard drive space (since this i what is needed to preform a SP3 upgrade).  I have the following query that does seem to filter the systems, but instead of the traditional view of Name, Domain, User, OS Name, OS version, etc etc.  I would like it to just show the OS Revision, Free Space, and the name of the system.  When I run a sql query directly against the database I get the desired results but when i paste that query into NS I get the result but not the correct view.  Here are some examples:

Select
  vri1_Computer.Guid As _ResourceGuid,
  [dca2_AeX AC Identification].[OS Revision],
  Inv_HW_Logical_Disk.[Free Space (Bytes)],
  [dca2_AeX AC Identification].Name
From
  vRM_Computer_Item As vri1_Computer Inner Join
  Inv_AeX_AC_Identification As [dca2_AeX AC Identification]
    On vri1_Computer.Guid = [dca2_AeX AC Identification]._ResourceGuid
  Inner Join
  Inv_HW_Logical_Disk On [dca2_AeX AC Identification]._ResourceGuid =
    Inv_HW_Logical_Disk._ResourceGuid
Where
  [dca2_AeX AC Identification].[OS Revision] = 'Service Pack 2' And
  Inv_HW_Logical_Disk.[Free Space (Bytes)] >= 1181116006 And
  Inv_HW_Logical_Disk.Name = 'c:' And
  vri1_Computer.IsManaged = 1 And
  vri1_Computer.ResourceItemDeleted = 0 And
  [dca2_AeX AC Identification].[OS Name] Like N'Microsoft Windows XP%' And
  Inv_HW_Logical_Disk.[Logical Disk Type] = 3

But when I do the same query in NS I get this:

I would like the fields under filter membership that has Name, Domain, User etc to reflect the first image above.

Any help would be appreciated!

Comments 3 CommentsJump to latest comment

mclemson's picture

You created a filter, not a report.  A filter with computers as members is going to show that Name, Domain, User, OS Name, etc information by default.  This cannot be changed.

A report lets you display the columns you want.  You should create a report if you need to show folks the free disk space.

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

resendesw's picture

Ok..was so a Homer Simpson moment.  :)

I just need a way to filter the system so I know which computers to target for a scripted install of SP3

Let me give that a go....

Thanks

BugTastic's picture

Just create a new SP2 filter using the fields in the screenshot. You can then apply your job to that filter.

Or you can enter the SQL

SELECT
   [vri1_Computer].[Guid],
   [vri1_Computer].[Name]
FROM
   [vRM_Computer_Item] AS [vri1_Computer]
      LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca2_AeX AC Identification]
         ON ([vri1_Computer].[Guid] = [dca2_AeX AC Identification].[_ResourceGuid])
WHERE
   (
      (
         ([dca2_AeX AC Identification].[OS Revision] LIKE N'%Service Pack 2%')
      )
   )
 

Also, another handy link :

http://www.symantec.com/business/support/index?page=content&id=HOWTO21576

Joe.

Capture.JPG