Category Archives: System Administration

Creating 2048 bit and SHA-2 Certificate request in SBS 2008 and Server 2008

Now that google chrome is “warning” about SHA-1 hashed certificates and most certification authorities seem to be issuing only 2048 bit encryption ones it is a good idea to update any certificates with the lower level hashing and encryption. The … Continue reading

Posted in System Administration | Tagged , , | Comments Off on Creating 2048 bit and SHA-2 Certificate request in SBS 2008 and Server 2008

Get list of Active directory groups and members

$allgroups=get-adgroups $t = foreach ($g in $allgroups) { $m = get-adgroupmember $g foreach ( $me in $m ) { $me | add-member -membertype noteproperty -name “groupname1” -value $g.name -force } $m | select } $t | select *groupname, name | … Continue reading

Posted in Powershell, VBS, VBA and other scripting., System Administration | Comments Off on Get list of Active directory groups and members

Archiving windows event logs.

If you select the option in windows event logs to archive old event logs it will create files of the format that event viewer can open. An event ID 1105 will be created as the first item in the new … Continue reading

Posted in Hints and Tips, System Administration | Comments Off on Archiving windows event logs.

Backing up SQL Express Databases

A scheduled script such as this which has hard coded the name of the sql command file, set it to run in the folder containing the backups echo %0 starting date /t time /t dir sqlcmd -S localhost\caserver -i “%programfiles%\custom\sql_express_database_name_backup.sql” … Continue reading

Posted in Hints and Tips, System Administration | Comments Off on Backing up SQL Express Databases

Giving permissions in Exchange for users from a trusted domain.

After a recent consolidation we needed to give users in a seperate (but trusted) domain access to mailboxes on an exchange 2010 server. The below code (copied from https://social.technet.microsoft.com/Forums/exchange/en-US/d2f051f0-9649-4ac0-8e82-9783a34d0eed/how-do-you-grant-full-mailbox-permissions-to-someone-in-a-different-domain-in-exchange-2010?forum=exchange2010 – by J. Duke Rogers Communicore Technologies & Triangle Forensics) does … Continue reading

Posted in Powershell, VBS, VBA and other scripting., System Administration | Comments Off on Giving permissions in Exchange for users from a trusted domain.

Self Signed Certificates.

Allows you to create longer lasting self signed certificates for testing new-selfsignedcertificate in powershell is pretty good but doesnt allow more than 12 months expiration. selfssl7 allows up to 50 years and 2048 bit size. Its default behavior is to … Continue reading

Posted in Powershell, VBS, VBA and other scripting., System Administration | Comments Off on Self Signed Certificates.

export all mailboxes exchange 2010

To do a bulk mailboxexport on exchange 2010 for all mailboxes, it mus tbe to a share and the share needs appropriate permissions. Filter the get-mailbox to get a subset of the mailboxes. $a=get-mailbox foreach ($u in $a) { $u.alias … Continue reading

Posted in Powershell, VBS, VBA and other scripting., System Administration | Comments Off on export all mailboxes exchange 2010

excel get domain from email address

=RIGHT(C2,LEN(C2)-SEARCH(“@”,C2))

Posted in System Administration | Comments Off on excel get domain from email address

GetMailboxStatisticsAndEmail.PS1

Script to export a list of all the mailboxes in an organisation and send the results as attachments to an email. Gives a list ordered by size and after that ordered by last logon time (to hilight old inactive mailboxes). … Continue reading

Posted in Powershell, VBS, VBA and other scripting., System Administration | Comments Off on GetMailboxStatisticsAndEmail.PS1

WSS3 sharepoint upgrade to Sharepoint Foundation 2013

WSS3 sharepoint upgrade to Sharepoint Foundation 2013 SBS 2003 and 2007 use the WSS3 version of sharepoint. To upgrade from that to a current version can be a bit tricky. It involves upgrading to the 2010 version of sharepoint foundation … Continue reading

Posted in System Administration | Leave a comment