get-user -filter {Title -eq “InterneServices”} | select name
Category Archives: Computer
Powershell – Get Mailbox permission search on title = InterneServices
$File = “C:\ita\fulldadgang-services.txt”
$AllUsers = get-user -filter {Title -eq “InterneServices”} | select name
$AllUsers | Foreach {
echo “”
echo “”
echo “”
echo $_.name
Get-MailboxPermission -identity $_.name
} | out-File $File
Powershell – Get-DistributionGroup with all email addressess
$File = “C:\ita\groupslog.txt”
Get-DistributionGroup | select name , alias ,displayname,EmailAddresses | foreach {
“Name: “+$_.name
“Alias: “+$_.alias
“Displayname“ +$_.displayname
$_.EmailAddresses | foreach {
if($_.SmtpAddress){
“SmtpAddress: “+$_.SmtpAddress
}
}
} | out-File $File
Microsoft Excel har fundet en fejl og afsluttes. Vi beklager ulejligheden ved afslutning af Excel
Nå du lukker et Excel ned, så kan den komme den og sige: Microsoft Excel har fundet en fejl og afsluttes.
Dette kan muligvis løses ved at gå ned i start og vælg kø, skriv her: regedit og tryk kør
Gå nu til HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins
Her er det et punkt der hedder noget med bluetooth, gå ind under denne og sæt LoadBehavior key fra 3 til 0. Således at den nu står til 0 (Nul). Genstart så Excel og prøv at lukke programmet
howto export mailbox size to CSV file Exchange 2007/2010
Howto Export all mailbox’es and there size to a CSV file
get–mailbox | get-mailboxstatistics | select-object DisplayName,TotalItemSize,StorageLimitStatus,LastLogonTime | Export-Csv c:\exchange.csv
Recovery IOS image with help of serial (console) and xmodem
This guide is only for recovery of a broken IOS image on you Cisco switch!.
First download a new image from Cisco. Is require a Cisco login, ask you dealer for a login for Cisco or a IOS image for you switch.
- Download Tera Term Pro: http://hp.vector.co.jp/authors/VA002416/teraterm.html
- Connect to the serial port in Tera Term Pro – Setup -> Serial port.
Port: Com2 (Or what you serial port number is)
Baud rate: 9600
Data: 8 bit
Parity: none
Stop: 1 bit
Flow control: noneThen press OK
- Now you are connect to the switch and the switch shows “switch: “, here type:
flash_init
set BAUD 115200 - Now the serial speed is set to 115200, so the transfer will go a lot faster, so we just need to disconnect tera term and connect again with the new baud rate.
In Tera term go to File – Disconnect - Now we need to setup a new connection – Setup -> Serial port.
Port: Com2 (Or what you serial port number is)
Baud rate: 115200
Data: 8 bit
Parity: none
Stop: 1 bit
Flow control: noneThen press OK.
- Now we are connect with baud rate 115200, then type:
copy xmodem: flash:image_filename.bin
Where image_filename.bin, is the filename of the image, if you image lastname is .tar you need to unpack it first. Use 7zip for that. http://www.7-zip.org/download.html - Then wee need to send the image to switch choise File -> transfer -> send in tera term.
And pick up you new image file, and wait for tera term to finish. - After the upload has finish type:
boot flash:image_filename.bin - Then the image will boot. Now you need to setup the switch so it will boot automatic on that image everytime you reboot the switch, go to configure terminal (conf t)
- Here you type:
boot system flash:image_filename.bin
And maybe you want to set the baud rate to default 9600 agian
line con 0
speed 9600 - exit the configure terminal and type:
wr mem
Now you are finish recovery you switch.
Test Exchange remote connectivity
Microsoft have launch a new webpage to test Exchange remote connectivity.
It can test:
ActiveSync
Activesync autodiscover
Outlook autodiscover
Microsoft Exchange Web Services Connectivity Tests
Outlook Anywhere (RPC over HTTP)
Outbound SMTP E-Mail
A problem occurred while trying to use your mailbox
Today i have a user that could get access to the exchange webmail. (OWA).
There are som solutions for this error, try to fix from bullet number 1, and down.
- Get-Mailbox User_Name | format-list ExchangeVersion
if the version is below 0.1 the run this command:
Set-Mailbox User_Name -ApplyMandatoryProperties - 1. Open ADUC, and go to the properties of the user that is having problems.
2. Click the Security tab, and then the Advanced button.
3. Make sure the “Allow inheritable permissions from the parent to propagate to this object…” is checked.
4. Give AD time to replicate the change and try to login in via OWA again. - Restart the Information Store service.
- 1. Open ADUC, and go to the properties of the user that is having problems.
2. Click the Security tab, and then the find the account SELF.
3. Give it fuld access.
4. Give AD time to replicate the change and try to login in via OWA again. - If all this dosen’t work, disable the user in Exchange EMC, this will delete the mailbox, so remember to have a backup of the account first. Then create a new mailbox to this user, and create the user again, and restore the mailbox from your backup.
Howto shrink / truncate SQL transaction log file in SQL Server 2005
USE <databasename>
GO
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
BACKUP LOG <databasename> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)
GO
Microsoft SQL (MSSQL) query for active session
Howto see active sessions in a mssql.
Its pretty easy just make a new query, and run sp_who or sp_who2.
sp_who shows whitch active sessions there are, and sp_who2 shows more information about the users.