• Home»
• Help»
• Parent 

• Share
• Print

PQL parent() function

The parent() function returns the parent of the node used as an argument, and the tree of that parent. This includes both the argument node and all of its siblings.

Syntax

The parent() function returns a tree and takes 2 parameters, a tree and a string:

tree parent(tree input, string input)

Examples

You can try the following examples against your own data in the GoToManage search field, or against fictitious data in the Query Sandbox:

• Example 1: Find parents of in_octets nodes
• Example 2: Find parents of software nodes
• Example 3: Find parents of system nodes

Example 1: Parent of in_octets node

Query: What are the parents of the in_octets nodes?

SELECT parent(in_octets)
FROM /network/device/interface

Results: Depending on the database, this query returns results similar to this:

row
  parent(in_octets)
    interface
       name vlan1
       mac_address 00:10:DB:4C:BA:68
       admin_status 2
       oper_status 2
       type 6
       speed 0
       out_errors 0
       in_errors 0
       mtu 1500
       out_octets 0
       in_octets 0
       descr vlan1
       if_index 4
row
  parent(in_octets)
    interface
       name ethernet2
       mac_address 00:10:DB:49:98:00
       admin_status 2
       oper_status 2
       type 6
       speed 10000000
       out_errors 0
       in_errors 0
       mtu 1500
       out_octets 0
       in_octets 0
       descr ethernet2
      inet
         ip_address 1.4.6.26
         netmask 255.255.255.248
       if_index 3  
    . . .

Example 2: Parents of software nodes

Query: What are the parents of the installed software nodes?

SELECT name, parent(name)
FROM /network/device/wmi/win32_product 
WHERE installdate > '20080101'

Results: Depending on the database, this query returns results similar to this:

row
   nameAltoworks Crawler
  parent(name)
    win32_product
       name Altoworks Crawler
       description Altoworks Crawler
       version 1.0.98.3306
       vendor Altoworks
       caption Altoworks Crawler
       installdate 20080418
       identifyingnumber {D074E45B-13ED-463C-898C-0A2FDC0D3A3E}
       skunumber
       installlocation C:\Program Files\Altoworks\Altoworks Crawler\
       packagecache C:\WINDOWS\Installer\b0bc08d.msi
       installstate 5 Installed
       installdate 220080418000000.000000-000
row
   nameWindows Media Encoder 9 Series
  parent(name)
    win32_product
       name Windows Media Encoder 9 Series
       description Windows Media Encoder 9 Series
       version 9.00.2980
       vendor Microsoft Corporation
       caption Windows Media Encoder 9 Series
       installdate 20080308
       identifyingnumber {E38C00D0-A68B-4318-A8A6-F7D4B5B1DF0E}
       skunumber
       installlocation
       packagecache C:\WINDOWS\Installer\a016a.msi
       installstate 5 Installed
       installdate 220080308000000.000000-000 
   . . .

Example 3: Parents of system nodes

Query: What are the parents of the system nodes with low disk space?

SELECT parent(systemname) 
FROM %free disk space% 
WHERE freespace < 1000000000
AND description = 'Local Fixed Disk'

Results: Depending on the database, this query returns results similar to this:

row 
  parent(systemname) 
    win32_logicaldisk 
       name C: 
       description Local Fixed Disk 
       size 18161414144 Bytes 
       creationclassname Win32_LogicalDisk 
       caption C:

To see other PQL functions, see Functions.