• Main page
  • IT
  • Private
  • All tags

Log In

  • Forgot your password?
  • Forgot your username?
  • Create an account
06Feb

Viewing and deleting the OCSP and CRL cache on Windows. Verifying certificate validity.

Written by Super User. Posted in IT

In some cases you may want to revoke certificate and then check on client computer that the certificate is invalid.

Because of caching of CRLs and OCSP in Windows operating systems, this will not be available until you clear CRL and OCSP cache.

Read more ... Add new comment

Print Email

30Jan

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

Written by Super User. Posted in IT

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?

Read more ... Add new comment

Print Email

28Jan

Export array (table) into csv-file in Powershell

Written by Super User. Posted in IT

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.
Read more ... Add new comment

Print Email

28Jan

Export Active Directory users to MS SQL Server

Written by Super User. Posted in IT

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.
 

Read more ... 2 comments

Print Email

28Jan

DataTable export into Excel table in web-project

Written by Super User. Posted in IT

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.
 

Read more ... Add new comment

Print Email

More Articles ...

  • Running Powershell script in scheduled task
  • Running Acronis Backup & Recovery on Windows Server 2012
  • Default URLs for default Enterprise CA installation
  • Enable Enterprise Voice for all users in Lync Server 2010/2013
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17

Choose language

  • English
  • Deutsche
  • Russian

Tags

  • powershell (ru) 40
  • script 29
  • скрипт 20
  • exchange 2013 (ru) 19
  • powershell (en) 16
  • lync 2013 (ru) 13
  • exchange (ru) 13

All materials are the propery of the author. Reposting is possible with the back-link to the original page to this blog.

Яндекс.Метрика