Type Definition for data collection of INFOR Application information Type Definition for data collection of Application Server information Type Definition for the application Common collections. The Application (Product) Name. Also can be referred to as the Product Line The Application (Product) full version. This is the version reported by the actual software code. The Product Line release is the external label of the release as customers are using it in the support portal. In the support portal, the release is really at the Product level, not the Product Line level. Products within a Product Line can have different release numbers as a Product Line has mainline products and add on products, etc. We can use a default release at the Product Line level, which should be an indication of the mainline products. The full root install path for the application The data location (datastore) for the application data (e.g. IP Address of the database) If a product has mutiple data stores (e.g. mutiple databases) identify the datastore (e.g. datastore name). The date and time that the configurator was last run The user id that last ran the configurator The product key installed for the entity being reported If a product has mutiple product keys (e.g. licensed by module) identify the licensed entity (e.g. Module name). A product Line has many products. The support portal uses the product entitlement to determine what to show and have access for. Optionally the ISA product integrations can return the products installed. A Product has a release. The support portal organizes all KB articles (including patches) at the Product/Release level. Optionally the ISA product integrations can return the release of the products installed. If absent, the proactive logic will use the Product Line release as default. Application Server Name - Middleware that the appplication is running on e.g. weblogic, tomcat IIS Application Server Type - the type of middleware that the application is using e.g. webserver, application server Application Server Version - the version of the application server type Database Name Database Product Type; Vendor e.g. Oracle, Enterprise SQL Server Full version of the Database SQLServer: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') Oracle: select * from v$version where banner like ‘Oracle%’; Function of the database (if known); e.g. Dev, Test, Live Server Address of the application Database (hostname) Type Definition for data collection of Database information Type of Log file - i.e. what is being logged Full path to the logfile including the log name if you roll log-files over like the Apache logs, you can put in a wild-card extension. Example Apache /var/log/apache2/access.log* access.log = current access.log.1.gz = old access.log.2.gz = old Oracle: show sga; Oracle: show parameters; Oracle Tablespace definitions SQL Server Full path of the database file SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf',LOWER(physical_name)) - 1) DataFileLocation FROM master.sys.master_files WHERE database_id = 1 AND FILE_ID = 1 SQL Server Size of the database file SELECT DB_NAME(database_id) AS DatabaseName, Name AS Logical_Name, Physical_Name, (size*8)/1024 SizeMB FROM sys.master_files WHERE DB_NAME(database_id) = '%databasename%' GO SQL Server Full path of the database log file SQL Server Size of the database log file SQL Server Size of the Transaction Log Oracle redo log files select member, group#, bytes, status from v$logfile;