This example shows how to create a web service with PowerShell that queries an IVANTI EPM database to get a computer name based on a MAC address. It includes setting up a Pode server, configuring an API endpoint, and running a SQL query to retrieve the information
Comprehensive guide for installing SCCM, including prerequisites, SQL Server setup, feature installation, SCCM configuration, and role installation.
Learn how to efficiently open the required SQL ports using the netsh command-line tool in Windows. This guide provides step-by-step instructions to manage firewall rules for SQL Server communication.
Learn how to resolve the error encountered when restoring a database on a new SQL server if the SQL account already exists. This guide provides a simple command solution to address the issue.
Migrate the LANDESK database to a new SQL server, including stopping services, backing up and restoring the database, and updating configurations.
This article provides essential SQL queries for checking and rebuilding fragmented indexes in your EPM database. Regular maintenance using these queries can enhance database performance and ensure smooth operations. Learn how to implement these steps effectively in your SQL Server environment.
This article provides a comprehensive guide to installing and configuring the Core Server for EPM. It includes steps for database creation, setting up service accounts, configuring the scheduler, managing certificates, and configuring COM+ objects. It also covers patch management and activation procedures.