To import the required tasks it is necessary to import the reports from the template on the Task tab of RayVentory Data Hub.
Data collection > Inventory > ECM
Either select ECM SQL, ECM WMI, or both.
Imported tasks:
ECM SQL - Microsoft SQL Server connector parameters:
•Connection tab
oConnection string: This parameter represents the full connection string used to connect to the database. This is a mandatory parameter that mus be completed either in the Edit task dialog or in the Variables tab: ###SCCM_CONNECTION_STRING###.
Example (connection to an SQL Server instance):
Server=myServerAddress\myInstanceName;Database=myDataBase;UserID=myUsername;Password=myPassword;
Example (using a trusted connection):
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
ECM WMI - SCCM (via WMI) connector parameters:
•Connection tab
oAPI: This parameter specifies which API option to use to execute the queries on the target SCCM machine. The user has two options to choose from: SM (System Management) and MMI (Microsoft Management Infrastructure). The SM option is set by default.
oAccess type: this parameter determines what access type should be used to connect to the target server. It is used if the "MMI" API is selected. The user has two options to choose from: DCOM (Distributed Component Object Model) and WSMan (Web Service Management). The DCOM option is set by default.
oHost: This parameter represents the target hostname. This is a mandatory parameter that must be specified either in the Edit task dialog or in the Variables tab: ###SCCM_WMI_HOST###.
A custom string value [Hostname or FQDN] can be used.
oUser name: This parameter represents the password for the specified user. It can take a custom security string value.
oSite: This parameter represent the SMS-Site name. This is a mandatory parameter that must be specified either in the Edit task dialog or in the Variables tab: ###SCCM_WMI_SITE###.
It can take a custom string value.
Once all mandatory parameters have been specified, all ECM tasks can be triggered.
1.Select all tasks available in the 1. Data collection > Inventory > ECM folder in the Tasks tab.
2.Click on the Run button located at the top of the page.
All tasks should now be completed successfully.
ECM SQL tasks:
The following tables will be created in the database for the ECM SQL tasks:
•dbo.SCCMSQLCollections
•dbo.SCCMSQLDeviceRelations
•dbo.SCCMSQLDevices
•dbo.SCCMSQLSoftwareARP
•dbo.SCCMSQLSoftwareFile
•dbo.SCCMSQLSoftwareFileMetering
•dbo.SCCMSQLSoftwareOS
•dbo.SCCMSQLSoftwareTag
•dbo.SCCMSQLUsers
ECM WMI tasks:
The following tables will be created in the database for the ECM WMI tasks:
•dbo.sccm_wmi-Hardware
•dbo.sccm_wmi-Software
•dbo.sccm_wmi-SoftwareFileMetering
•dbo.sccm_wmi-UserDeviceRelations