Posted by paris on Aug 27, 2015 in Random
Basic MOC instructions for MatWorx
Open Matworx then go to Function -> MOC
Notes for using MOC
Press [/] to get into command mode
If you get stuck just press [/] to go back to command mode
[space] is used to enter data, it feels wrong not to use enter
[enter] is used cycle through output from commands
[.] is used for committing data
[CCC.] is used for deleting items so be careful
You will need to do this to find out your incoming Route :
3512>ISDN Route>3 = 3 incoming digits
3518>ISDN Route>0 = allow digit conversion.
Call forward all DID Calls ( external ) from xxxx to xxxy
Remove the external call forward
Posted by paris on Aug 24, 2015 in Random
Recently a customer had to go through a Software Licensing Self-Assessment with Accordo for their current Adobe installations
“I am from Accordo Group Limited (“Accordo”). Accordo has been authorised by Adobe to communicate with your organisation and assist with the Adobe Licensing Self-Assessment (“Licensing Self-Assessment”) process.
Please note that Accordo is an independent consulting organisation, providing advice on software licensing matters. We do not sell software licenses. “
This is a third party Adobe works with to audit their existing customers to check compliance. The process involved filing out an “Adobe Deployment Summary” excel sheet, to list all the software installed in your environment which can be audited internally either manually or through some software such as SpiceWorks ( for a Manual scan) or if deployed can be listed in SCCM.
You will also need to provide Proof of Purchase for these licenses for any Retail discs ( online purchases should be direct with Adobe so the companies Adobe ID can be provided ). Receipts should be provided for Adobe CC subscriptions.
We had an issue for this some CS2 Adobe Retail products we still used where older that the legal 7 year financial retention needed. We liased this onto our Licensing Consultant who agreed products purchased over 7 years ago would only need the Proof of ownership ( pictures of CD’s and license ) not the receipt.
After this , a “Estimated License Ownership Position” was produced showing the company compliance for future record.
Posted by paris on Aug 20, 2015 in Random
Use to find the current firmware
To do the disk FW upgrade on the background, check the following is enabled:
Disk Firmware Update Location : http://mysupport.netapp.com/NOW/download/tools/diskfw/
Download the .LOD files to \\fascontrollerip\c$\etc\disk_fw
Disk firmware files should have been installed correctly to the system. Within two minutes the system should detect and begin updating any eligible drives.
Check this setting is enabled
Disk Shelf Update Location : http://mysupport.netapp.com/NOW/download/tools/diskshelf/
Download the .SFW files to \\fascontrollerip\c$\etc\shelf_fw
storage download shelf
Posted by paris on Aug 19, 2015 in Random
iOS 7 and iOS 8 will send the correct passcode compliance status to the VSP whenever the device is unlocked. The issue only manifests itself when the device is locked with a passcode.
Its under Admin portal –> Logs&Events –> Event Settings –> Select the Policy Violation Event –> Edit
Untick Passcode is not compliant
Posted by paris on Aug 17, 2015 in Fixes
Recently we had an issue where a Aggrigate on a netapp grew by 10% over the weekend. A check on the volumes showed nothing had grown which suggested something in the Aggrigate layer.
We called NetApp Support who confirmed it was a known bug
Deduplication identifies and removes duplicate blocks in a volume, storing only unique blocks.
Deduplication requires the use of a certain amount of metadata, including a ‘fingerprint‘ summary to keep track of data in the blocks. When the data in the blocks changes frequently, the fingerprints become stale.
sis start command is running, any stale fingerprint metadata is normally detected and removed. If the deletion of stale fingerprint metadata fails, the stale fingerprint data will linger and consume space in the volume, and can significantly slow deduplication processing.
sis start command is running on a flex volume, the deduplication subsystem of Data ONTAP performs in several phases:
- Fingerprint gathering
- Fingerprint sorting
- Fingerprint compressing
- Block sharing
Normally, if the fraction of stale fingerprints in the database increases to greater than 20 percent, an additional ‘fingerprint checking’ phase is also performed, which cleans up the data. However, there is an issue in some releases of Data ONTAP (Data ONTAP 8.1, 8.1.1 and 8.1.2 and P/D-patch derivatives) that might cause the percentage to be calculated incorrectly, such that the checking phase is never performed. For more information, see BUG ID: 657692.
The stale fingerprints in the fingerprint database are not deleted; the excess data lingers and consumes space in the volume.
As more stale fingerprints accumulate, the increasing size of the fingerprint metadata increases the deduplication workload on the system, with the sorting and merging phases running for a long time. In aggravated cases, storage clients might experience a slow response.
This issue is more likely to be observed on a volume where there is a lot of file delete activity.
To determine if a flex volume on a storage system is experiencing this issue, the output of two administrative commands can be examined for numeric values from which a calculation can be made. The commands are:
sis check -c <vol>
sis status -l <vol>
Note: Run the
sis check command from the diag node.
The output of
sis check -c for a volume includes the following lines:
Checking fingerprint ... 18115836411 records
Number of Segments: 3
Number of Records: 18003077302, 53607122, 59151987
Checking fingerprint.vvol ... 56538330 records
Checking fingerprint.vvol.delta ... 2665604040 records
The important value is in the first line, the total of checked records, 18115836411, which will be called ‘TOTALCHECKED’ here.
In the output of
sis status -l for the same volume, the following line is included:
Logical Data: 3509 GB/49 TB (7%)
The important value is displayed first, the size of the logical data, 3509.
Take the logical-data size (in gigabytes) and apply the following calculation, which yields the number of storage blocks occupied by the logical data.
LOGICALBLOCKS = (LOGICALSIZE * 1024 * 1024) / 4
In this case,
(3509 * 1024 * 1024) / 4 = 919863296 is the LOGICALBLOCKS value.
To calculate the percentage of stale fingerprints, take the total of checked records from the
sis check -c output and use it in the following equation:
PERCENTSTALE = ((TOTALCHECKED - LOGICALBLOCKS) * 100) / LOGICALBLOCKS
In this case,
((18115836411 - 919863296) * 100) / 919863296 gives a PERCENTSTALE result of 1869.
As the result, 1869 is much larger than 20. The conclusion is that the triggering of
sis check at 20 percent stale did not occur, and thus the volume and storage system are experiencing the issue.
A cleanup of the fingerprint database on a volume impacted by this issue is accomplished by running the following command:
sis start -s <vol>
This is resource intensive and a very long-running process as it deletes (entirely) the old Fingerprint Database to reclaim volume space and then builds a brand new copy of the Fingerprint Database.
If the workload imposed on the storage system by running
sis start -s is extremely large, a NetApp Support Engineer can guide the user to use the following advanced-mode command on the impacted volume:
sis check -d <vol>
Note: Dedupe operations for any new data will not be performed while ‘
sis check -d‘ is running, expect to use more space from the volume until this command finishes.
In addition, the ‘
sis check -d’ command requires an amount of free space in the volume greater than or equal to twice the size of the Fingerprint Database files. You can estimate the size of the Fingerprint Database by running ‘
sis check -c‘ and adding the number of records in three files, then multiplying by 32 bytes which is the size of each record. To estimate the amount of free space required, in bytes, use this formula:
Number of records in [fingerprint.vvol + fingerprint.vvol.delta + fingerprint.vvol.delta.old (if present) ] * 32bytes = records (or database size)
Ensure that there is sufficient free space prior to running ‘
sis check -d’.
'sis check -d' is invalid on a snapvault secondary
Users should upgrade to Data ONTAP release 8.1.2P4 or later.
After upgrading to a release with the fix, running deduplication twice
(sis start) on each volume will automatically remove these stale fingerprints.
Note: If there is no new data added to the volume, deduplication will not go through all its phases, including the phase responsible for cleaning up stale fingerprints (Verify Phase). Deletes on the volume would not cause deduplication to initiate. Data deletions from the volume will definitely create stale fingerprint metadata in the volume.
The first deduplication job post upgrade might take longer time than expected. Subsequent operations will complete at normal operating times. This process of removing the stale fingerprints will temporarily consume additional space in both the deduplication enabled FlexVol volumes and their containing aggregates.
Also, to confirm that the controller running Data ONTAP version with the fix is not witnessing this issue, please check sis logs. Logs should have the following two lines mentioned:
<timestamp> /vol/<volname> Begin (sis check)
<timestamp> /vol/<volname> Sis Verify Phase 1
You can do the formula in the Link to check if it’s applying to you to check PERCENTSTALE is over 20
Run theses on all of the volumes which come back with PERCENTSTALE is over 20 , run once at a time to stop high I/O on San
priv set advanced
sis check -c /vol/volume
sis status -l /vol/volume
Upgrade Ontap to new version
Posted by paris on Jul 25, 2015 in Wordpress
Recently upgrading a customer wordpress plugins I got greated with a
Call to undefined function doing_action()
When trying to login to the admin section , this was on Line 616 in file /google-analytics-for-wordpress/admin/class-admin.php
Comment this line out ( change to
//return doing_action( 'yst_ga_aggregate_data' ) && defined( 'DOING_CRON' ) && DOING_CRON;
Which will let you login to wordpress , update the wordpress version , and re-uncomment the line and save
return doing_action( 'yst_ga_aggregate_data' ) && defined( 'DOING_CRON' ) && DOING_CRON;
Posted by paris on Jul 25, 2015 in Random
When your Lun useage shows useage that does not match your datastore useage you will need to perform a reclaim on the lun. This can be done manually using the putty commands on a VMWare host attached to the datastore
vmkfstools -y %percenttoclear%
It is recommended that the %percenttoclear% increases from say 10% up to 80% in 10% Blocks
There’s a nice script here : https://kallesplayground.wordpress.com/2014/04/03/storage-reclamation-part1/ to automate the increase
****WARNING**** Do only one reclaim at a time , and it sharpley increases the IOP’s on the San to best to do out of hours
We had to do a few of these out of hours at around 3am , I actually automated this as a scheduled task using putty’s plink.exe which meants it ran in the very early hours of the morning! I couldn’t use the Kallesplaygroup .sh script as this didn’t work sending from plink , the script would have to be on the local esx box which it’s practical to to the multiple hosts our current cluster runs
FYI you will see you have to manually enter the password. A more recommended solution would be to use certificate authentication with putty
plink.exe %esxboxwithsshenabled% -ssh -batch -l root -pw %rootpasswordofesxbox% -m C:\Scripts\filewithabovelinesin.sh > c:\log.txt
Posted by paris on Jul 24, 2015 in Code
Worksite/Imanage Monitor can export a document list based on History using the History search but it’s limited in the way it can display comments as well as duplicate Document Numbers. Below is SQL of how to get this direct in SSSM
Change the WorksiteDB to your DB and APPName to your application
SELECT DISTINCT [WORKSITEDB].[MHGROUP].[DOCHISTORY].[DOCNUM]
, CAST([WORKSITEDB].[MHGROUP].[DOCHISTORY].[COMMENTS] AS NVARCHAR(MAX))
FROM [WORKSITEDB].[MHGROUP].[DOCHISTORY] JOIN [WORKSITEDB].[MHGROUP].[DOCMASTER] ON [WORKSITEDB].[MHGROUP].[DOCHISTORY].[DOCNUM]=[WORKSITEDB].[MHGROUP].[DOCMASTER].[DOCNUM] WHERE (APPNAME = 'APPLICATIONNAME') AND (ACTIVITY = 'Checkin')
Posted by paris on Jul 23, 2015 in Random
Get the port number on the switch , if you stack you should get the switch number as well
You can use show int to list all the interfaces , get the switch port value e.g. gi/1/0.8
Use sh int gi1/0/8 to list the port details to make sure its up etc
Next run :
show mac address-table int gi1/0/8
( copy the address it gives you Address )
Next Run this
show arp | incl %macaddressofabove%
If it doesn’t show anything the device might not have an IP ( check port is on correct Vlan )
** A cheat , on a computer connected to the switch on the same Vlan and IP range , you can manually add an IP to the mac address then try and ping/access the device :
In Windows Xp
arp -s %spareip% %macAddress%
In Windows 7
netsh -c interface ipv4 add neighbors “Network Card Name” “IP Address” “MAC Address”
Posted by paris on Jul 19, 2015 in Random
Login to SCCM server with a user who is a member of USR_SCCM_Admins group
First you will want to creation a collection ( selection of computers ) who you can test the policy with. SCCM has some premade ones, segregating Workstations and Servers with Operating Systems
Create a new collection ( right click New ) Choose a Name and Click Next
Add an Individual PC can be added by choosing This Red High-Lighted Button and Using the Query to the left
Choose a Group of Computers Such as an OU can be added by using the Blue Highlighted button and the query below
Download the Application MSI from the website
Create a new Package – Enter the Name
Choose the datasource as a folder location in \\sccmserver\share$\Applications and you can leave everything else as defaults (if you only have one site)
After creation of the above Folder , copy all the files you need to install into this directory e.g. the MSI and and BAT Files. The Bat files might look something like this
echo . Installing Adobe Flash Player 18 - Please Wait
REM Installs Adobe Flash Player 18 and disables autoupdate checking
REM Install Adobe Flash Player ActiveX
msiexec.exe /qb /norestart /i "%~dp0install_flash_player_18_active_x.msi"
REM Installing Adobe Flash Player Plugin
msiexec.exe /qb /norestart /i "%~dp0install_flash_player_18_plugin.msi"
REM Disable Auto Updates
REM Copy flash config file to C:\WINDOWS\system32\Macromed\Flash\
xcopy "mms.cfg" "C:\WINDOWS\system32\Macromed\Flash\" /Y
if exist "C:\Windows\SysWOW64\Macromed\Flash\" xcopy "%~dp0mms.cfg" "C:\Windows\SysWOW64\Macromed\Flash\" /e /i /h /y
if exist "C:\Windows\System32\Macromed\Flash\" xcopy "%~dp0mms.cfg" "C:\Windows\System32\Macromed\Flash\" /e /i /h /y
REM Return exit code to SCCM
exit /B %EXIT_CODE%
After creating the Package you need to Create a Program which references the files
Under the Package Program Folder , right click on Programs and choose New
Enter and Name and in Command Line reference the .bat file
Choose Next and choose the self-explanatory options
Distribute the Package via Advertisement
There are multiple ways to distribute a program through SCCM , but I prefer using the advertisement as it can be straight away!
Choose the options above and Choose the Package, Program and Collection you would like to deploy to
Choose Next , where you can put the start time this will which the advertised app will appear in peoples control panel
To force this to run for all users you will need to add a Mandatory Assignments Task where you can also set a schedule or immediate start time
Follow through the rest of the self-explantory options and click go when ready.
Sit back and wait!
To Check Status of the rollout
Software Distribution / Packages / Choose your Package / Pack Status / Your Office and click on the right hand Actions Show Messages and Choose ALL Choose the day range and click OK