PowerShell Data Collector

Products Access Analyzer Show & Tell
, ,
1

PowerShell Data Collector

The PowerShell Data Collector in Netwrix Access Analyser is a highly powerful & versatile tool. You can:

  • Pass configuration variables from the Console GUI
  • Use credentials stored in Connection Profiles
  • Process data from an input table
  • Output data to a results table
  • Run the script on the Console Server or on a target Windows host

Here are some examples of where I have used the PowerShell Data Collector:

File Share Management
I have used the PowerShell Data Collector as part of a File Share Management process. This process incorporates the creation of File Shares and its respective AD groups, file share deletion and existing file share imports.

I have also created a similar process for Azure File Shares which uses the Azure cmdlets for share creation, group assignment, etc. This process also required the use of a Connection Profile containing the Azure Client ID and Secret in order to authenticate to Azure.

Sending Emails
You can use the PowerShell Data Collector & the Send-MailMessage cmdlet to send emails.

To achieve this, I first set up the variables for the SMTP configuration, such as SMTP Server, Sender Address and Subject. This allows these settings to be easily set / modified from the console GUI without needing to open the code.

I then use an input table which contains the recipient information as well as any other information that should be included in the email.

When the job runs, the PowerShell will process each row in the input table one by one, sending an email for each row.

Data Collection
The PowerShell Data Collector can be used to collect data from anywhere PowerShell can connect to. Some examples of where I have used this:

  • Entra ID Users
  • Entra ID Devices
  • AutoPilot Devices
  • Microsoft 365 Reports
  • Secret Server Credential Information
3 Likes