SQL

Inventory Microsoft SQL Server Information with Configuration Manager 2012

Accurately inventory and report on Microsoft SQL Server Instances with SCCM 2012 It is ironic that Configuration Manager provides such basic inventory capabilities for products such as Microsoft SQL Server and Microsoft Exchange. This solution addresses the limitations of attempting SQL Server inventory with the native inventory information available. Specifically this solution provides the following information for SQL Server versions, tested as far back as SQL 2005, and provides the following information for all SQL Instances detected:- Collation Edition EditionType FeatureList InstallPath InstanceName Language PatchLevel ProductCode ProductID ServicePack Version An example of the inventory data is shown below:- An example...

Continue reading...

Writing Custom ForeFront Identity Manager Reports

Introduction:- I have had the opportunity to work with ForeFront Identity Manager for a long time and in all that time I have never had sufficient requirements to deploy the Systems Center Service Manager Data Warehouse integration. Specifically as the most common requirement is to do long-time archival of all requests for auditing and compliance, I have been using a stored procedure to extract the FIM requests and store these in a dedicated FIM Request Archive and  Reporting database. Occasionally, the FIM deployment may have some requirements around object reporting and although there may be a lot of warnings and...

Continue reading...