Login to the Nable Administrator Report Manager ( http://%reportmanagerserver%/Interface/Pages/menu.aspx ) 

You will need to use the username : reportsadmin@n-able.com ( You can reset this password ) 

Navigate to the following

1. Select System Setup and Logs
2. Select Data Retention settings

Depending on your retention modify the below per here

Open SQL Server Management Studio make sure you have maintenance plan set up on the ODS Database

• Set the following in the Maintenance Plan Wizard of Microsoft SQL Server Management Studio:
•  Set the plan properties Name to Report Manager and Daily Run out of hours 

  2. Select the following maintenance tasks for the ODS databases and the warehouse database

• Check Database Integrity
• Reorganize Index
• Update Statistics

If you backup via another utility you can cancel the below : 

• Back Up Database (Full)
• Maintenance Cleanup Task

After the maintenance plan ran , we ran a Shrink on the database to reduce a 400GB Database file back down to 50GB for 3000 Devices

*SolarWinds MSP does not recommend shrinking your database.* however this was needed due to the ODS build up

• No Comments

Recently installed the Plugin NextGen Pro to enable the Nextgen Pro Lightbox this would work on some galleries and others it would just display the below.

Turns out some of the shotcodes were wrong on the Gallery Page

Readding these resolved the issue

[ngg_images source="galleries" container_ids="7" display_type="photocrati-nextgen_pro_mosaic" row_height="180" margins="5" last_row="justify" lazy_load_enable="1" lazy_load_initial="35" lazy_load_batch="15" captions_enabled="0" captions_display_sharing="1" captions_display_title="1" captions_display_description="1" captions_animation="slideup" order_by="sortorder" order_direction="ASC" returns="included" maximum_entity_count="500"]

• No Comments

Can be done in powershell : https://gallery.technet.microsoft.com/office/Copy-folder-structure-from-99b46508

Or :

Map the Sharepoint Document Library to a Network Drive

Now run this which will replicate the folders Locally ( xcopy to Sharepoint Library does not work ) 

xcopy “X:\1718ClientFinancesTA\*”  “C:\Temp\FY\*” /T /E

Now Use Windows Explorer to copy the folders in C:\Temp\FY\ to your new Folder in Sharepoint

• No Comments

1. Add your sharepoint site to your trusted sites 
2. Navigate to your Sharepoint Library in ( Internet Explorer ) and on the right hand side choose VIEW in File Explorer

3. 

4. If you are in the old version of Sharepoint you might need to go here

5. 

6. On the screen that pops up copy the File path at the top

7. 

8. https://%sharepointsite%.sharepoint.com/sites/Library/Folder
9. Select This PC and MAP network Drive

10. 

11. Enter the URL in this link

12. 

• No Comments

Avaya IP Office upgrade from R10 and above to R11

Part 1:

Either the Business Partner or Distributor log onto PLDS and access the End Users Activation record for the site they want to upgrade.

Using the Host ID is the easiest way

Or you can search on the FL ID

Once you have the record you need check the licenses under “View Summary” and make sure they are R10 and above

Next choose “Options” then “Upgrade”

Check details then click “Next”

Check all the “Qty to Upgrade” quantities match the “Avail to Upgrade” quantities. You may notice the number of licenses here do not match exactly to what they have in the Summary. That is because a lot of the existing R10 licenses can be used on the R11 systems

Choose “Request Paid Upgrade Entitlement” from the drop-down box and press “Select”

Check the “Qty Needed” and “Request Qty” match then click “Next”

Add the email/s to where you want the record sent and press “Finish”

The Upgrade Request Notification that is received has the licenses and their amounts that must be crreated in Avaya One Source for the upgrade

Part 2:

Log into Avaya One Source (A1S) and create a new quote

Choose IP Office Software Upgrade and enter the Business Partner name

Now this is where it is different. Since you are upgrading an R10 system, under existing choose R10.

The Target will automatically change to R11 and you will need to select how many nodes you are upgrading. This is determined by how many Server Edition licenses were in the Upgrade Request Notification (in this case 1). (If the upgrade is for an IP500v2 it will always be 1). Once done click “Continue”

Choose the correct Solution Type. SMB is for an IP500v2. Mid-Market is for a Server Edition. Then go to Physical Location 1.

If there is a valid IPOSS support contract in place for this site, choose “Yes”. In not it is obviously no. Enter the Host ID that this site is using

Under the “Existing” column, add the licenses as they are in the Upgrade Request Notification that was retrieved from PLDS. The “Target” column should automatically update. (Note: not all licenses are available in R11. The Avaya Softphone in this case. If you cant add it make note and advise the Business Partner). Click “Next”

If there is a valid existing support contract the support can be left at 0, otherwise add support if need be.

Save and then Configure Design and you are done. Make sure you note what IPOSS support contract is to be used when the order is placed

• No Comments

https://blogs.technet.microsoft.com/exchange/2018/07/16/issue-with-july-updates-for-windows-on-an-exchange-server/                 

• No Comments

New Users

1 ) 2fa Enabled for Users

Get-mailbox -Filter {(RecipientTypeDetails -eq 'UserMailbox')} | ForEach {Set-Mailbox $_.Identity -LitigationHoldEnabled $true }

Get-mailbox -Filter {(RecipientTypeDetails -eq 'UserMailbox')} | ForEach {Set-Mailbox $_.Identity -AuditEnabled $true}

Maintenance Tasks

• No Comments

Recently upgraded a IPV500 v2 phone system from Version 9 to 10 and had a phone stuck on 

Discover xxx.xx.xxx.x

To perform a reset in the Craft Menu you can try clearing the phones values so that when it establishes DHCP again it’ll point to the PBX (as long as the port its connected to has a route to the PBX).

Reboot the phone and when you see the “Press * to program” screen, press it and try entering the passcode as (CRAFT) 27238#.. Thats the default so it may not work on all phones. If it works, scroll down to “Clear values” and select it.

• No Comments

On the Fortigate , Create a new Interface and assign it to the Uplink of your internet or DMZ with a Vlan ID and Enable DHCP

Create a policy to allow outbound

On the Switch ( ours GS752TP ) that the access points plug into,  Tag the ports with the Vlan ID you created above, where your access points plug into as all as the port for the Uplink from the Switch to the Router

On your access points  ( Ours WNDAP360 ) create a new SSID and Tag these to the new VLAN ID

• No Comments

Recently had a customer on Small Business Server think someone might be logging into the server as him. To check logs in IIS for a user : 

1 )Download and install Log Parser 2.2

2 ) Copy the logs from the default Location 

C:\inetpub\logs\LogFiles\W3SVC1 

to C:\Temp\Logs\

3) Save the following as query.sql in C:\Temp\Logs\

SELECT cs-username, date, time, c-ip, cs-uri-stem, cs(User-Agent) FROM C:\Temp\Logs\*
WHERE cs-method LIKE ‘%get%’ and cs-uri-stem LIKE ‘%owa%’

Run : 

Logparser.exe file:C:\Temp\Logs\query.sql -i:IISW3C -o:CSV

• No Comments