This Exports a report of emails and also a copy of all the emails to a mailbox ( Disovery ) you can do this via the Web Based Gui : https://youwebmaildomain/ecp/?rfr=owa with the right user permissions

New-MailboxSearch -Name "WeekendOutage-Search" -StartDate "1/1/2009" -EndDate "12/31/2009" -SourceMailboxes "Amit Tank" -TargetMailbox "Discovery Search Mailbox" -SearchQuery '"Weekend" and "Outage"' -MessageTypes Email -IncludeUnsearchableItems -LogLevel Full

But you cannot exclude emails from specific domains from this discovery search .e.g only sent from Externally. You can exclude Generic Keywords using NOT in the -SearchQuery but its generic to the email like the search Query above.

The New-MailboxExportRequest Should be able to do this but it doesn’t , just exports everything probably because the operator is too specific and doesn’t suport -notlike 🙁

New-MailboxExportRequest -Mailbox "Discovery Search Mailbox" -contentfiler{sender -ne "*@internaldomain.com"} -Filepath \\samba\share\withexchangepermissions\file.pst

But we can actually just delete all the Internal Mail using Search Mailbox

 

Search-Mailbox -Identity "Discovery Search Mailbox" -searchquery 'From:"@internaldomain.com"' -DeleteContent

Now we can just export this to a PST

New-MailboxExportRequest -Mailbox "Discovery Search Mailbox" -Filepath \\samba\share\withexchangepermissions\file.pst
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

owncloudNB : Are you running a 32bit OS?

 

cat /etc/0s-release

If Pretty_Name = i586 it means you are, means your file size can only be 2Gigabytes which means you can only set your max filesizes below to 2000M (any more and you will get Unable to set upload directory)

Php.ini ( timeouts )

vi /etc/php5/apache5/php.ini

post_max_size = 2000M

upload-max-filesize = 2000M

max_execution_time = 300  

Increase File Upload Size
Go to /srv/www/htdocs/owncloud/ and edit .user.ini and  the .htaccess

upload_max_filesize=2000M
post_max_size=2000M

Restart Apache

systemctl restart apache2.service


Installed from
 
https://susestudio.com/a/TadMax/owncloud-in-a-box
 
SSL
Install SSL ; http://www.unixmen.com/create-ssl-cetificates-in-opensuse-12-3/
Digicert Tool – https://www.digicert.com/easy-csr/openssl.htm
 
Install Multiple SSL’s – https://www.digicert.com/ssl-support/apache-multiple-ssl-certificates-using-sni.htm
 
Disk Useage
df -h
 
SSL Cert Locations
/etc/apache2/ssl.key/
 
Access Logs
/var/log/apache2
 
Error Logs
 /var/log/apache2
 
Apache Files
/srv/www/htdocs/owncloud
 
Php.ini ( timeouts ) ***NB*** Its a 32bit machine can only upload 2 Gigs
/etc/php5/apache5
 
max_execution_time = 300
 
Apache Running as user wwwrun
 
Increase File Upload Size
 
Go to /srv/www/htdocs/owncloud/ and edit .user.ini and  the .htaccess

upload_max_filesize=2000M
post_max_size=2000M
 

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

SQL

Shows all the databases of a server and the last time they were accessed

SELECT DatabaseName, MAX(LastAccessDate) LastAccessDate
FROM
    (SELECT
        DB_NAME(database_id) DatabaseName
        , last_user_seek
        , last_user_scan
        , last_user_lookup
        , last_user_update
    FROM sys.dm_db_index_usage_stats) AS PivotTable
UNPIVOT 
    (LastAccessDate FOR last_user_access IN
        (last_user_seek
        , last_user_scan
        , last_user_lookup
        , last_user_update)
    ) AS UnpivotTable
GROUP BY DatabaseName
HAVING DatabaseName NOT IN ('master', 'tempdb', 'model', 'msdb')
ORDER BY 2

Shows all the current database connections currently

SELECT @@ServerName AS server,NAME AS dbname,COUNT(STATUS) AS number_of_connections,GETDATE() AS timestampFROM sys.DATABASES sdLEFT JOIN sysprocesses sp ON sd.database_id = sp.dbidWHERE database_id NOT BETWEEN 1 AND 4GROUP BY NAMEORDER BY 3 


VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

worksiteWhen renaming a user in iManage/ Worksite the logs show

“[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with the name ‘Store’ already exists

The trigger in the DOCMASTER Table contains a cursor called Store which conflicts with the stored procedure. Choose modify on the trigger and do a search and replace Store another variable e.g. StoreTrigger. Execute the trigger after to save and try again

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

In Exchange EWS when trying to delete an item you get the following error : cannot find an overload for “delete” and the argument count 0 using

$item.Delete()

 

You need to give it a an enumeration e.g.

They can be found here : http://msdn.microsoft.com/en-us/library/microsoft.exchange.webservices.data.deletemode(v=exchg.80).aspx

$item.Delete([Microsoft.Exchange.WebServices.Data.DeleteMode]::HardDelete)

 

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Repeater8540_FrontWtop_HR_512Upgrading a Citrix branch repeater ( Now called CloudBridge)  to the latest firmware requires the License currently installed to be in date and under maintenance. If you renew your Citrix Maintenance you need to re-download all your licenses and reupload them to the branch repeater before it accepts the new firmware file.

Upon reuploading one of the new License file to a branch repeater I was given the error

Add License failed: The license is not an upgrade license which is required since a base license is already installed

This required me to delete the current license from the Citrix Branch Repeater ( Warning this will disconnect accelerated connections so make sure you do this out of production hours ) and reupload the license.

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

image1[1]Recently I was trying to take a backup of the configuration for a NetApp SAN for a scheduled power shutdown. Per this useful guide : http://pipe2text.com/?page_id=1472 this can be done through the OnCommand facility.

However once I tried to create the backup file I was given the error configuration plugin for data ontap version 8.1.1 is not installed. A look on Netapp Support shows I would need to download the software and install , however when I checked the below I only found version 8.1.3 which means I would need to reinstall and upgrade. I just wanted to get a config backup before the power down!!!

  1. Go to http://support.netapp.com & login using your account.
  1. Go to Download -> Software
  1. Go to the Data ONTAP download section and supply the model of your controller (FAS2240-4) and click “GO”.
  1. In the “Data ONTAP for FAS2240-4” page, find ONTAP 8.1.1 and click “View and Download” button.
  1. Scroll down to the section titled, “Support for OnCommand Core Package or Operations Manager and DataFabric® Manager server multiple-system configurations
  1. Click the link under that section titled “Data ONTAP 8.1.1 Operating in 7-Mode Plug-in for DataFabric Manager Server”.

So I found another way 🙂

1) Login to the netapp controllers indivdually via SSH ( not through the service port )

2) Run ‘config dump -v nameofbackup’, this will backup to the \etc\configs directory

3) Open \\nameofnetappcontroller\c$ ( Samba share )

4) Browse to \\nameofnetappcontroller\c$\etc\configs and copy the file off

VN:F [1.9.22_1171]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: +1 (from 1 vote)

keychain_problem[1]I recently went to fix 2 Macs that had been updated to Mavericks and were displaying login prompts below for Keychain Access

  • CalendarAgent
  • accountsd
  • AddressBookSourceSync

There are multiple fixes on the internet which eventually fixed them both

First Fix

  • Open Up Keychain Access
  • Click on Preferences
  • Go to General
  • Reset My Default KeyChain
  • Go back to Preferences then choose KeyChain First aid and run a repair and fix

Second Fix

  • In Finder Select Go in Top Toolbar while pressing the Option key and Click on Libray
  • Go into the /Keychains/ Folder
  • Look for a folder with a name similar to this “A8F5E7B8-CEC1-4479-A7DF-F23CB076C8B8”.
  • Move this folder to the Trash.
  • Immediately choose Apple Menu (?) > Restart… to restart your Mac.


Third Fix

  • Go into Keychain
  • Choose Preferences
  • Choose First Aid Tab
  • Choose “Syncronise login keychain password with account”

Try this if it’s asking you every 5 minutes, instead if just on startup.

http://www.igorkromin.net/index.php/2013/10/28/calendaragent-wants-to-use-your-login-keychain-messages-after-upgrading-to-os-x-mavericks/

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

J8699ARecently a HP 5406 Switch randomly crashed in the middle of a working day. A reboot fixed this however , we wanted to update the firmware from V12.16 to the latest version  K.15.09.0012, ROM K.15.28

The link to the latest firmware is here :

https://h10145.www1.hp.com/Downloads/SoftwareReleases.aspx?ProductNumber=J8697A&lang=en&cc=us&prodSeriesId=1827663

After backing up all the config, We downloaded the K.15.09.0012 firmware to start with. These switches have Primary and Secondary firmwares which allows some fault tollerence when it comes to an upgrade. If the Primary firmware fails it will switch to secondary so you can reflash

Upon trying to upload the K.15.09.0012, ROM K.15.28 via the web interface , it error-ed on Internet Explorer and Firefox with no immediate error. The next method we tried was a Telnet Firmware Upgrade , a bit more long winded.

We setup a TFPT server to be able to download the

Just download this free TFTP Server tool and setup defaults and copy the firmware to C;\TFPT ( or your default location )

Next we telneted into the Switch , and used the Command Menu to bring up the Switch Menu

We then went to Download OS , entered the TFTP IP of the PC with the file and the file name , and it brought back

Aborted, File Error

OK so the switch is bouncing back the file , probably because it’s referencing something with the current version ( The web interface should of been nice and told us this! )

After checking the ReadMe for the 15 upgrade , we found the following :

(BootROM K.12.12 – K.12.14)  Update and reload into software version K.13.58 or K.13.68

So we updated to K.13.68 (for BootROM updates only) via telnet which worked , and then updated to K.15.09.0012, ROM K.15.28

VN:F [1.9.22_1171]
Rating: 9.0/10 (6 votes cast)
VN:F [1.9.22_1171]
Rating: +2 (from 4 votes)

This resets the FRS Journal Wrap for the replications

  1. Click Start, and then click Run.
  2. In the Open box, type cmd and then press ENTER.
  3. In the Command box, type net stop ntfrs.
  4. Click Start, and then click Run.
  5. In the Open box, type regedit and then press ENTER.
  6. Locate the following subkey in the registry:
    HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\NtFrs\Parameters\Backup/Restore\Process at Startup
  7. In the right pane, double-click BurFlags.
  8. In the Edit DWORD Value dialog box, type D2 and then click OK.
  9. Quit Registry Editor, and then switch to the Command box.
  10. In the Command box, type net start ntfrs.
  11. Quit the Command box.
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)