Thought I’d share a strange SCCM Connection issue with the Ivanti Service Manager (HEAT ISM) Integration. Cloud, VPN, SCCM 2010
The 1st connection attempt fails with error: 40 – Could not open a connection to SQL Server
The 2nd connection attempt is successful (no changes made to settings)
This is an issue for scheduled SCCM imports that are set to nightly and the import shows as complete but actually fails with zero batches and records processed.
Manually running the connection experiences similar symptoms and testing the connection sometimes gives an error the first time around but is ok the second time around.
HEAT Ivanti Service Manager (ISM) SCCM Integration Issue with VPN Workaround:
To overcome this SCCM Integration issue, at first I attempted creating a second schedule with the same SCCM Integration but didn’t seem to work and the SCCM Integration ran, showed as completed, but had zero bathes and records.
Then created a second dummy SCCM Integration, with a filter that produced zero records, and scheduled it 15 minutes prior to the actual SCCM Integration.
That seems to have been working so far.
Ivanti finally came back and recommended to look into the “keep alive” setting on the VPN, as it may be getting in the way .
Asset Manager is a much talked about “new” product that was released with ITxM 2018.3 and actively promoted with ITxM 2019.1.
ITxM 2019 in fact consists of Ivanti Service Manager (ISM) and Ivanti Asset Manager (IAM).
Ivanti Asset Manager has been around for a while and Ivanti Service Manager, formerly known as HEAT, has done Asset Management since its early HEAT for Windows days in the 1990’s.
ITxM is a leap forward combining the best of both the Asset Manager product and HEAT’s Asset Management capabilities with a roadmap to dominate the ITxM space.
- Asset Roles
- Android Based Asset Scanning
- Improved Asset Interface
- Improved Integration for Discovery Tools such as EPM and SCCM
- Improved Asset Reports & Dashboards
- Improved Asset Life Cycle Statuses
- Simplified Asset Types, including Consumables
- Inventory Stock Management
- Contracts and Purchase Orders
- Improved Vendor Management
- Improved Software Library
- Improved Audit & Compliance Capabilities
- Improved Costing Reporting Capability (Total Cost of Ownership)
- Request Offerings (2019.3)
- Improved Asset Workflows
ITxM in essence becomes your single source of truth with a holistic view of your assigned assets, discovered assets, tracked against purchase orders, contracts with workflow and approval processes.
Lots of great functionality and features that on the surface provide a great demo and glimpse into what your Asset Management Strategy could look like, but overkill in practice.
For this reason I have developed an Asset Manager Best Practice System in working with dozens of clients over the last couple decades.
If you are serious about making your Asset Manager Strategy a success, be sure to contact me. I’m here to help!