What data is captured by Inventory Pack for Servers?

book

Article ID: 178400

calendar_today

Updated On:

Products

Inventory Solution Audit Integration Component Inventory Pack for Servers

Issue/Introduction

 

Resolution

Question
What data is captured by Inventory Pack for Servers?

Answer

 

 

 

 Below are the data classes and sample data from data captured by the Inventory Pack for servers task.

 

--AeX_AC_Basic_Inventory

AeX AC NT Services

AeX AC Roles

AeX AC TCPIP

AeX AC Identification

AeX AC Location

AeX AC Client Agent

AeX AC Primary User

AeX AC SMS Client Properties

 

select * from inv_AeX_Srv_Components

 

Name                                                                                                                     Status

  Connection Manager Administration Kit                                                              Disabled

  Connection Point Services                                                                                    Disabled

  Network Monitor Tools                                                                                        Enabled

  Simple Network Management Protocol                                                                Disabled

  WMI  SNMP Provider                                                                                         Disabled

  WMI Windows Installer Provider                                                                         Enabled

  Internet Explorer Enhanced Security Configuration Administrative Group          Enabled

  Internet Explorer Enhanced Security Configuration Other User Group                Enabled

  Email Services POP                                                                                              Disabled

  Email Services POP Admin                                                                                  Disabled

  Indexing Service                                                                                                   Enabled

  Simple TCP/IP Services                                                                                        Disabled

  Internet Authentication Service                                                                             Disabled

  RPC Over HTTP  Proxy                                                                                       Disabled

 

select * from Inv_AeX_Srv_IIS_Application_Pools

               

Application Pool Name  Recycle Worker Process Time (Minutes)  Recycle Worker Process Requests Status  Recycle Worker Process At Time  Virtual Memory Recycling (MB)  Used Memory Recycling (MB)  Idle Timeout Status  Timeout Value (Minutes)  Request Queue Limit Status  Number of Requests  CPU Monitoring Enabled  Max Number of Worker Processes  Pinging Enabled  Rapid Fall Protection Enabled  Startup time Limit (Seconds)  Shutdown time Limit (Seconds)  Apllication Pool Identity  Security Account

AeXHD  Disabled  Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   4000        No           1              Yes          Yes          90            90                Predefined               Network Service

AeXKB   Disabled  Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   4000        No           1              Yes          Yes          90            90                Predefined               Network Service

AeXRSASMExtAppPool       1740        Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   4000        No           1              Yes          Yes                90            90            PredefinedLocal System

AeXRSVaultPool   1740        Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   4000        No           1              Yes          Yes          90                90            Predefined               Local System

DefaultAppPool      1740        Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   4000        No           1              Yes          Yes          90                90            Predefined               NetworkService

PBSAppPool          1740        Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   4000        No           1              Yes          Yes          90                90            Predefined               Network Service

WbfrAppPool         1740        Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   4000        No           1              Yes          Yes          90                90            Predefined               Local System

Workflow                1740        Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   4000        No           1              Yes          Yes          90                90            Predefined               Network Service

ReportServer           1740        Disabled  Disabled  Disabled  Disabled  Disabled  NA          Enabled   4000        No           1              Yes          Yes          90                90            Predefined               Network Service

VMware Management Pool    1740        Disabled  Disabled  Disabled  Disabled  Enabled   20            Enabled   1000        No           1              Yes          Yes                90            90            Predefined               Local System

 

 

select * from inv_AeX_Srv_IIS_FTP_Site_Details

 

_id           FTP Site Name      Path                        Rights

6              Default FTP Site     c:\inetpub\ftproot     Read

 

select * from inv_AeX_Srv_IIS_Status

 

IIS Version IIS Service SMTP Service BITS Service NNTP Service Internet Internet Printing Front Page Server Entensions ASP Net ASP COM Plus Service Network DTC Message Queue Service Application Server Console Internet Data Connector Remote Admin Remote Desktop Web Connection Server Side Includes WebDAV WWW Service Acccess Denied Message

6.0           Enabled   Enabled   Enabled   Enabled   Enabled   Enabled   Enabled   Enabled   Enabled   Not Installed            Enabled   Enabled   Not Installed                Not Installed            Not Installed            Not Installed            Not Installed            Disabled  Error: Access is Denied.

 

select * from inv_AeX_Srv_IIS_Web_Service_Extensions

 

Extension Name    Status

ASMExt  Allowed

ASP.NET v1.1.4322               Allowed

ASP.NET v2.0.50727             Allowed

ASPack.exe             Allowed

Active Server Pages                Allowed

AeXMigrt.exe         Allowed

AeXRSVault           Allowed

All Unknown CGI Extensions                Prohibited

All Unknown ISAPI Extensions            Prohibited

CDViewer.exe        Allowed

EfsConv.exe            Allowed

Internet Data Connector          Prohibited

PSNGen.exe           Allowed

RPC Proxy Server Extension  Allowed

Server Side Includes               Allowed

WebDAV                Allowed

mod_gsoap on AMTSCS       Allowed

pclean.exe                Allowed */

 

 

select * from inv_AeX_Srv_IIS_Web_Site_Details

 

Website Name  Connection Timeout (Seconds)  Logging Enabled  Bandwidth Throttling Enabled  Bandwidth Throttling Limit (KBPS)  Process Throttling Enabled Maximum CPU Use Percentage  Enforce Process Throttling  Connection Limit  Content Location  Content Location Path  Access  Execute Permission  Application Name  ASP Script Timeout (Seconds)  Session State Enabled   Session Timeout (Minutes)  Buffering Enabled  Parent Paths Enabled  Default ASP Language  Content Expiration Enabled  Content Expiration Settings  Anonymous Access Enabled  Integrated Authentication Enabled Basic Authentication Enable  Digest Authentication Enabled  Dot Net Passport Authentication Enabled  Certificates Enabled  Application Pool  Default Document Enabled  Default Document Name  TCP Ports  SSL Ports  Host Headers

Default Web Site     900          No           No           Unlimited                NA          NA          NA          Unlimited                A directory on Local Machine                c:\inetpub\wwwroot                Read        Script       Default Application 90            Yes          20            Yes          No           VBScript No           NA                No           Yes          No           No           No           Yes          DefaultAppPool      Yes                Default.htm,Default.asp,index.htm,iisstart.htm,Default.aspx  80            443          NA          19

Administration        120          Yes          No           Unlimited                NA          NA          NA          Unlimited                A directory on Local Machine                C:\WINDOWS\system32\serverappliance\web      Read        Script       Default Application 90            Yes          20            Yes          No                VBScript No           NA          No           No           Yes          No           No           Yes          DefaultAppPool      Yes          Default.asp              8099                8098        NA          20

Workflow                120          Yes          No           Unlimited                NA          NA          NA          Unlimited                A directory on Local Machine                C:\workflow            Read,Write,DirectoryBrowsing               Script,Executables   Default Application 90            Yes          20            Yes          No                VBScript No           NA          Yes          Yes          No           No           No           No           DefaultAppPool      Yes                Default.htm,Default.asp,index.htm,Default.aspx     81            NA          NA         

 

select * from inv_AeX_Srv_MS_SQL_Server_Databases

 

Instance Name  Database Name  Data File Size (MB)  Space Available (MB)  DB Owner  Number of Users  Collation  Data File Path  Automatically Grow File  Data File Growth Mode  Data File Growth Size

KENSLAP1            AeXRSDatabase     1024        413.79000000000002             KENSLAP1\Administrator     5              SQL_Latin1_General_CP1_CI_AS                C:\AeXRSDatabase\AeXRSDatabase_Data.mdf    True         Percent    10            230

KENSLAP1            Altiris      4889        2476.3200000000002             NULL     5              SQL_Latin1_General_CP1_CI_AS        C:\Program Files\Microsoft SQL Server\MSSQL\data\Altiris.mdf           True         Percent    10            231

KENSLAP1            Altiris_Incidents      19            2.4199999999999999             NULL     5              SQL_Latin1_General_CP1_CI_AS        C:\Program Files\Microsoft SQL Server\MSSQL\data\Altiris_Incidents.mdf           True         Percent    10            232

KENSLAP1            eXpress   8              2.7200000000000002             KENSLAP1\Administrator     3              SQL_Latin1_General_CP1_CI_AS                C:\Program Files\Microsoft SQL Server\MSSQL\data\eXpress.mdf     True         Percent    10            233

KENSLAP1            eXpress68sp2         11            5.9100000000000001             KENSLAP1\Administrator     4              SQL_Latin1_General_CP1_CI_AS                C:\Program Files\Microsoft SQL Server\MSSQL\data\eXpress68sp2.mdf           True         Percent    10            234

KENSLAP1            IntelAMT                3              0.53000000000000003           NT AUTHORITY\SYSTEM 4              SQL_Latin1_General_CP1_CI_AS                C:\Program Files\Microsoft SQL Server\MSSQL\data\IntelAMT.mdf  True         Percent    10            235

KENSLAP1            Northwind               3              0.71999999999999997           sa             4              SQL_Latin1_General_CP1_CI_AS        C:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf      True         Percent    10            236

KENSLAP1            pubs        2              0.41999999999999998           sa             3              SQL_Latin1_General_CP1_CI_AS        C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs.mdf              True         Percent    10            237

KENSLAP1            SEDB      9              9.0199999999999996             KENSLAP1\Administrator     4              SQL_Latin1_General_CP1_CI_AS                C:\Program Files\Microsoft SQL Server\MSSQL\data\SEDB_Data.MDF            True         Percent    10            238

KENSLAP1            Software Manager Database   74            70.150000000000006             KENSLAP1\Administrator     4                SQL_Latin1_General_CP1_CI_AS        C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Software Manager Database.mdf   True                Percent    10            239

KENSLAP1            Wise Services Database          50            49.5         KENSLAP1\Administrator     4              SQL_Latin1_General_CP1_CI_AS                C:\Program Files\Microsoft SQL Server\MSSQL\data\Wise Services Database.mdf            True         Percent    10            240

KENSLAP1            Workbench Database              50            49.210000000000001             KENSLAP1\Administrator     4                SQL_Latin1_General_CP1_CI_AS        C:\Program Files\Microsoft SQL Server\MSSQL\data\Workbench Database.mdf                True                Percent    10            241

KENSLAP1\KENS2005        Symantec_CMDB   255          11.59       KENSLAP1\Administrator     4              SQL_Latin1_General_CP1_CI_AS                C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Symantec_CMDB.mdf              True         Megabyte                1              */

 

 

select * from inv_AeX_Srv_MS_SQL_Server_Logins

 

Instance Name   Login Name

KENSLAP1            AeXRSDatabaseUser            

KENSLAP1            AMTSCS_KENSLAP1.ALTIRIS_9Sb?_4Be      

KENSLAP1            KENSLAP1\Administrator    

KENSLAP1            KENSLAP1\AltirisAppID    

KENSLAP1            KENSLAP1\kspinder            

KENSLAP1            KENSLAP1\SEAdmin          

KENSLAP1            sa            

KENSLAP1            test          

KENSLAP1            WiseSvcA063814AFD374928927D91320E3B113A           

KENSLAP1            BUILTIN\Administrators      

KENSLAP1            NT AUTHORITY\NETWORK SERVICE          

KENSLAP1\KENS2005        NT AUTHORITY\SYSTEM

KENSLAP1\KENS2005        sa            

KENSLAP1\KENS2005        BUILTIN\Administrators      

KENSLAP1\KENS2005        KENSLAP1\SQLServer2005MSFTEUser$KENSLAP1$KENS2005

KENSLAP1\KENS2005        KENSLAP1\SQLServer2005MSSQLUser$KENSLAP1$KENS2005               

KENSLAP1\KENS2005        KENSLAP1\SQLServer2005SQLAgentUser$KENSLAP1$KENS2005

 

select * from inv_AeX_Srv_MS_SQL_Server_Processors

 

Instance Name  Processors  Threads Allocated

KENSLAP1            2              255

KENSLAP1\KENS2005        2              0 

 

select * from inv_AeX_Srv_MS_SQL_Server_Startup_Parameters

 

Instance Name  Startup Parameter

KENSLAP1            -dC:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf   

KENSLAP1            -eC:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG 

KENSLAP1            -lC:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf    

KENSLAP1\KENS2005        -dC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf             

KENSLAP1\KENS2005        -eC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG            

KENSLAP1\KENS2005        -lC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf              

 

select * from inv_AeX_Srv_MS_SQL_Server_Transaction_Logs

 

Instance Name   Database Name  Log File Path  Log File Size (MB)

KENSLAP1            AeXRSDatabase     C:\AeXRSDatabase\AeXRSDatabase_log.LDF     43            97

KENSLAP1            Altiris      C:\Program Files\Microsoft SQL Server\MSSQL\data\Altiris_log.LDF                1744        98

KENSLAP1            Altiris_Incidents      C:\Program Files\Microsoft SQL Server\MSSQL\data\Altiris_Incidents_log.LDF               2              99

KENSLAP1            eXpress   C:\Program Files\Microsoft SQL Server\MSSQL\data\eXpress_log.LDF             2              100

KENSLAP1            eXpress68sp2         C:\Program Files\Microsoft SQL Server\MSSQL\data\eXpress68sp2_log.LDF   5              101

KENSLAP1            IntelAMT                C:\Program Files\Microsoft SQL Server\MSSQL\data\IntelAMT_log.LDF          1              102

KENSLAP1            Northwind               C:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf     1              103

KENSLAP1            pubs        C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs_log.ldf     1              104

KENSLAP1            SEDB      C:\Program Files\Microsoft SQL Server\MSSQL\data\SEDB_Log.LDF              13            105

KENSLAP1            Software Manager Database   C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Software Manager Database.ldf     47                106

KENSLAP1            Wise Services Database          C:\Program Files\Microsoft SQL Server\MSSQL\data\Wise Services Database_log.LDF    1              107

KENSLAP1            Workbench Database              C:\Program Files\Microsoft SQL Server\MSSQL\data\Workbench Database_log.LDF        1              108

KENSLAP1\KENS2005        Symantec_CMDB   C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Symantec_CMDB_log.LDF      173                */

 

select * from inv_AeX_Srv_MS_SQL_Server

 

Instance Name  Version  Audit Level  Memory Allocation Type  Memory Allocated (MB)  SQL Query Memory (KB)  Index Creation Memory (KB)  Index Creation Memory Type  Collation  Default Language  Agent Service Running  Server Running  Full text Search Installed  MSCTC Service Running  Enabled Protocols  Linked Server Names  Authentication  Service Account  Max Concurrenct Users Allowed  Automatic ANSI to OEM Conversion  Use International Settings  Replication Working Directory  SQL Path  SQL Executive Mail AutoStart  SQL Server Updated Version

KENSLAP1            8.00.194  None       Dynamic  2147483647            1024        0              Dynamic  SQL_Latin1_General_CP1_CI_AS        us_english                Running  Running  True         True         TCP/IP,Named Pipes              kensclient2,kenstest4,kenstest2,ADSI    Mixed      .\administrator                Unlimited                ON          ON          C:\Program Files\Microsoft SQL Server\MSSQL\REPLDATA            C:\Program Files\Microsoft SQL Server\MSSQL       False        8.00.761  14

KENSLAP1\KENS2005        9.00.1399.06           Failure     Dynamic  2147483647            1024        0              Dynamic  SQL_Latin1_General_CP1_CI_AS                us_english               Stopped   Running  True         True         TCP/IP,Shared Memory         NA          Mixed      LocalSystem            Unlimited                NA          NA          C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\REPLDATA          C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL     False        NA         

 

select * from inv_AeX_Srv_Network_NIC_Count

 

Total Count  Physical NIC Count Virtual NIC Count

9              2              7

 

 

select * from inv_AeX_Srv_Network_NIC_Details

 

Name  Link Speed Mode  Link Speed (Mbps)  Network Card Status  Driver

VMware Virtual Ethernet Adapter for VMnet8      Half Duplex            100          Enabled   VMware Virtual Ethernet Adapter for VMnet8      105

VMware Virtual Ethernet Adapter for VMnet1      Half Duplex            100          Enabled   VMware Virtual Ethernet Adapter for VMnet1      106

Cisco Systems VPN Adapter  NA          NA          Disabled  Cisco Systems VPN Adapter 

Juniper Network Connect Virtual Adapter              Half Duplex            1000        Enabled   Juniper Network Connect Virtual Adapter             

WAN Miniport (AppleTalk)   Half Duplex            0              Enabled   WAN Miniport (AppleTalk)  

WAN Miniport (Network Monitor)        Half Duplex            0              Enabled   WAN Miniport (Network Monitor)        110

Broadcom NetXtreme 57xx Gigabit Controller       Half Duplex            100          Enabled   Broadcom NetXtreme 57xx Gigabit Controller       111

WAN Miniport (IP)                Half Duplex            0              Enabled   WAN Miniport (IP)                112

Direct Parallel          NA          NA          Enabled   Direct Parallel          113

WAN Miniport (PPPOE)       NA          NA          Enabled   WAN Miniport (PPPOE)       114

WAN Miniport (PPTP)          NA          NA          Enabled   WAN Miniport (PPTP)          115

WAN Miniport (L2TP)           NA          NA          Enabled   WAN Miniport (L2TP)           116

RAS Async Adapter               NA          NA          Enabled   RAS Async Adapter               117

1394 Net Adapter    NA          NA          Disabled  1394 Net Adapter   

 

select * from inv_AeX_Srv_SCSI_Controllers

 

Availability  Caption  Description  Device ID  Driver Name  Manufacturer  Name  PNP Device ID  Protocol Supported  Status  Status Information

Running/Full Power                LSI Logic 1020/1030 Ultra320 SCSI Adapter        LSI Logic 1020/1030 Ultra320 SCSI Adapter                PCI\VEN_1000&DEV_0030&SUBSYS_01831028&REV_08\5&2362145E&0&200010 SYMMPI                LSI Logic                LSI Logic 1020/1030 Ultra320 SCSI Adapter         PCI\VEN_1000&DEV_0030&SUBSYS_01831028&REV_08\5&2362145E&0&200010 EISA       OK                Enabled   8

Running/Full Power                DELL CERC SATA 1.5/6ch RAID Controller      DELL CERC SATA 1.5/6ch RAID Controller                PCI\VEN_9005&DEV_0285&SUBSYS_02911028&REV_01\5&13ADAA24&0&480210             cercsr6     Adaptec   DELL CERC SATA 1.5/6ch RAID Controller        PCI\VEN_9005&DEV_0285&SUBSYS_02911028&REV_01\5&13ADAA24&0&480210             EISA       OK                Enabled   9

Running/Full Power                D347PRT SCSI Controller     D347PRT SCSI Controller     PCI\D347PRT\0000               d347prt    (Standard mass storage controllers)              D347PRT SCSI Controller     PCI\D347PRT\0000               EISA       OK          Enabled  

 

 

select * from inv_AeX_Srv_System_DSN

 

Name                                     Description                          Data Source         Type                      Driver                   Driver ID

Altiris eXpress Database         Microsoft SQL Server            NA                          SQL Server             NA                          44

kenslap1                                  NA                                          NA                          SQL Server             NA                          45

LicAdmin                                Microsoft SMS Software Metering UI DSN          NA                          SQL Server             NA          46

License Server                         Local DSN                              NULL                     NA          Microsoft Visual FoxPro Driver             NA          47

LocalServer                             NULL                                     NA                          SQL Server             NA                          48

SiteServ   Microsoft SMS Software Metering Service DSN  NA          SQL Server             NA          49

test                                           NA                                          NA          SQL Server             NA          50

WBEM Source                        NA                                          NA          WBEM ODBC Driver            NA