Links
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 Certificate, SSL, Windows Server.
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