Archiving and recovering (export) private key in Active Directory Certification Services (ADCS)

When you have your Active Directory Certification Services (ADCS), your domain users can have certificates used to encrypt\decrypt emails. Your security department may want to get access to those encrypted emails, so you must provide private key of this user, so security-people can decrypt messages.

How can you do that?

  • Hits: 21201

Export array (table) into csv-file in Powershell

In your work in big arrays of data in Powershell, very often you will need to export data to table and after open this table in Excel. Its not recommended to code direct export from array into Excel-file, because you will need Excel installed on computer where you run the script. Also, such a code will run slowly.
So, I've decided to export data to csv-file.
  • Hits: 34066

Export Active Directory users to MS SQL Server

Today's my script was written while i've been developing billing-system for Asterisk.

Every user in Active Directory has an attribute with phone number. We will take this attribute and some others into MS SQL Server to use in billing.

There are tons of scripts that can export AD users into scv-file, but none that will export users directly to SQL database. Of course we can export users into scv and then take this csv and import it into SQL database with the help of SSIS-scripts. But this method will generate two scripts, and if you have more than 5-10-15 AD domains, you will have 10-20-30 scripts, which is likely will lead to errors.
 

  • Hits: 12750

DataTable export into Excel table in web-project

I've been working on Asterisk billing fow a while (computing some kind of tables). And i've got a need to create quite complex reports periodically.

With my experience in coding, this task will be so difficult, so I decided to export my tables to Excel and then create report in this powerfull table processor.
 

  • Hits: 2669

Running Powershell script in scheduled task

Like any other scripts, you will need to run Powershell-scripts not in manual mode, but as a scheduled task.

For example, mass importing and actualizing Lync Server users database you will need to run every one-two-three hours.

Of course, Task Scheduler in Windows should help in this issue, but how to run *.ps1 file?

  • Hits: 4245

Running Acronis Backup & Recovery on Windows Server 2012

Running Acronis Backup & Recovery on Windows Server 2012

It becomes clear that Acronis didnt released build of Acronis Backup & Recovery, that will work on Windows Server 2012. Actually - support was not declared, but we can start Backup & Recovery on 2012 ... with a little trick.

Sympthoms: after Backup & Recovery installation, management console didnt start with reference to "Acronis Managed Machine Service" (the service didnt start) (service name - MMS).

  • Hits: 6143

Default URLs for default Enterprise CA installation

In case if you re broken default Extensions settings in Microsoft Enterprise Certificate Authority, you can check the default settings here. I was needed this information when I deleted LDAP distribution points.

  • Hits: 2520

Page 11 of 13