Collecting Infrastructure Information - Collecting and Importing Data (Part 2/3)

This is second part of our video series on how to collect domain infrastructure information using Sys-Manage CopyRight2's Infrastructure Reporting module.

This is the second part of our video series on how to collect domain infrastructure information using Sys-Manage CopyRight2's Infrastructure Reporting module. The video explains how to define computer and LDAP scan jobs to collect inventory data and a scan import job to import it into the SQL server database.

Video

Download Video

Environment

The server that SQL-Server 2016 and the Reporting Services were installed on in this video is running Windows 2012 R2. You could install it on a newer version of Windows, for example Windows 2016 or 2019 as well. The system has the 64-bit version of CopyRight2 installed.

Settings (Computer Scan Job)

Job Type
Computer Scan

Name and Description Page
Name: Server Scan Job

Computers Page
Static list of computer(s) to be scanned:
WIN2K12R2
WIN2K12R2FS

Settings Page
Export format: Database (Access MDB format)

File Services Page
All options enabled including file hashes (RIPEMD160).

Software Page
All options enabled

Security (SAM) Page
All options enabled

Settings (LDAP Scan Job)

Job Type
LDAP Scan

Name and Description Page
Name: Active Directory Scan Job

Settings Page
Domain Controller: WIN2K12R2

Settings (Scan Import Job)

Job Type
Scan Import

Name and Description Page
Name: SQL Import Job

Jobs Page
Scan Jobs:
Server Scan Job
Active Directory Scan Job
Import to Microsoft SQL server database: Enabled
SQL Server Name: WIN2K12R2

Notes

You could schedule the defined jobs for background execution in an interval after their definition if you want the SQL data to get updated automatically.

COPYRIGHT2 TRIAL

Free Download

GET SOCIAL