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
[Computer1] AeXRSDatabase 1024 413.79000000000002 [Computer1]\[Administrator] 5 SQL_Latin1_General_CP1_CI_AS C:\AeXRSDatabase\AeXRSDatabase_Data.mdf True Percent 10 230
[Computer1] 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
[Computer1] 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
[Computer1] eXpress 8 2.7200000000000002 Computer1]\[Administrator] 3 SQL_Latin1_General_CP1_CI_AS C:\Program Files\Microsoft SQL Server\MSSQL\data\eXpress.mdf True Percent 10 233
[Computer1] eXpress68sp2 11 5.9100000000000001 [Computer1]\[Administrator] 4 SQL_Latin1_General_CP1_CI_AS C:\Program Files\Microsoft SQL Server\MSSQL\data\eXpress68sp2.mdf True Percent 10 234
[Computer1] 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
[Computer1] 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
[Computer1] 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
[Computer1] SEDB 9 9.0199999999999996 [Computer1]\[Administrator] 4 SQL_Latin1_General_CP1_CI_AS C:\Program Files\Microsoft SQL Server\MSSQL\data\SEDB_Data.MDF True Percent 10 238
[Computer1] Software Manager Database 74 70.150000000000006 [Computer1]\[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
[Computer1] Wise Services Database 50 49.5 [Computer1]\[Administrator] 4 SQL_Latin1_General_CP1_CI_AS C:\Program Files\Microsoft SQL Server\MSSQL\data\Wise Services Database.mdf True Percent 10 240
[Computer1] Workbench Database 50 49.210000000000001 [Computer1]\[Administrator] 4 SQL_Latin1_General_CP1_CI_AS C:\Program Files\Microsoft SQL Server\MSSQL\data\Workbench Database.mdf True Percent 10 241
[Computer1]\[Username] Symantec_CMDB 255 11.59 [Computer1]\[Administrator] 4 SQL_Latin1_General_CP1_CI_AS C:\Program Files\Microsoft SQL Server\#####.1\MSSQL\DATA\Symantec_CMDB.mdf True Megabyte 1 */
select * from inv_AeX_Srv_MS_SQL_Server_Logins
Instance Name Login Name
[Computer1] AeXRSDatabaseUser
[Computer1] AMTSCS_[Computer1].ALTIRIS_9Sb?_4Be
[Computer1] [Computer1]\[Administrator]
[Computer1] [Computer1]\AltirisAppID
[Computer1] [Computer1]\[Administrator]
[Computer1] [Computer1]\[Administrator]
[Computer1] sa
[Computer1] test
[Computer1] WiseSvcA063814AFD374928927D91320E3B113A
[Computer1] BUILTIN\Administrators
[Computer1] NT AUTHORITY\NETWORK SERVICE
[Computer1] NT AUTHORITY\SYSTEM
[Computer1] sa
[Computer1] BUILTIN\Administrators
[Computer1] [Computer1]\SQLServer2005MSFTEUser$[Computer1]$[Username]
[Computer1] [Computer1]\SQLServer2005MSSQLUser$[Computer1]$[Username]
[Computer1] [Computer1]1\SQLServer2005SQLAgentUser$[Computer1]$[Username]
select * from inv_AeX_Srv_MS_SQL_Server_Processors
Instance Name Processors Threads Allocated
[Computer1] 2 255
[Computer1]\[Username] 2 0
select * from inv_AeX_Srv_MS_SQL_Server_Startup_Parameters
Instance Name Startup Parameter
[Computer1] -dC:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf
[Computer1] -eC:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG
[Computer1] -lC:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf
[Computer1]\[Username] -dC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
[Computer1]\[Username] -eC:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
[Computer1]\[Username] -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)
[Computer1] AeXRSDatabase C:\AeXRSDatabase\AeXRSDatabase_log.LDF 43 97
[Computer1] Altiris C:\Program Files\Microsoft SQL Server\MSSQL\data\Altiris_log.LDF 1744 98
[Computer1] Altiris_Incidents C:\Program Files\Microsoft SQL Server\MSSQL\data\Altiris_Incidents_log.LDF 2 99
[Computer1] eXpress C:\Program Files\Microsoft SQL Server\MSSQL\data\eXpress_log.LDF 2 100
[Computer1] eXpress68sp2 C:\Program Files\Microsoft SQL Server\MSSQL\data\eXpress68sp2_log.LDF 5 101
[Computer1] IntelAMT C:\Program Files\Microsoft SQL Server\MSSQL\data\IntelAMT_log.LDF 1 102
[Computer1] Northwind C:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf 1 103
[Computer1] pubs C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs_log.ldf 1 104
[Computer1] SEDB C:\Program Files\Microsoft SQL Server\MSSQL\data\SEDB_Log.LDF 13 105
[Computer1] Software Manager Database C:\Program Files\Microsoft SQL Server\#####.1\MSSQL\Data\Software Manager Database.ldf 47 106
[Computer1] Wise Services Database C:\Program Files\Microsoft SQL Server\MSSQL\data\Wise Services Database_log.LDF 1 107
[Computer1] Workbench Database C:\Program Files\Microsoft SQL Server\MSSQL\data\Workbench Database_log.LDF 1 108
[Computer1]\[Username] Symantec_CMDB C:\Program Files\Microsoft SQL Server\#####.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
[Computer1] 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 [Computer2],test4,test2,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
[Computer1]\[Username] 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
[Computer1] 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