Resolved by following https://support.office.com/en-us/article/Office-repeatedly-prompts-you-to-activate-on-a-new-PC-a9a6b05f-f6ce-4d1f-8d49-eb5007b64ba1
Close the activation window and all Office apps.
- Right-click the Start button on the lower-left corner of your screen, and select Run.
- Type regedit, and then press Enter. Select Yes when prompted to open the Registry Editor.
- On the left side of the Registry Editor, under Computer, navigate to the following key in the registry:
- Right click the OEM value and click File>Export.
- Save the key.
- After the key is backed up, select Edit>Delete.
- Repeat steps 3-6 for the following key:
- Close the Registry Editor and start Office again.
Description of the task
I received an Excel spreadsheet with a list of personal data including names, telephone numbers, membership numbers and addresses. I wanted to plot the addresses on a map in a way that left only the postcode identifiable for reasons of data protection as a postcode alone will not be traceable to more than a street it conforms with the requirements of being personally identifiable. Therefore the task required two stages to complete:
- Anonymise personally identifiable data (offline on a secure computer)
- Plot anonymised data on Google Maps
My thanks to “Lisa in the Health Library” for her blog post which pointed me to Google Fusion Tables
Anonymise personally identifiable data
To anonymise the data I created an additional column in the identifiable spreadsheet named “ID” and populated it with a contigious record count from 1 through to the last row and then saved the edited identifiable spreadsheet.
I then created a second blank Excel spreadsheet (which I’ll refere to now as the anonymised spreadsheet) and copied both the postcode column and the newly created “ID” column from the identifiable spreadsheet into the anonymised spreadsheet and saved it under a new name.
I now have a working anonymised spreadsheet which only I can identify the owners of the postcodes by referring back to the “ID” field in the identifiable spreadsheet if needed.
Plot anonymised data on Google Maps
Using *only* the anonymised spreadsheet I then followed the guidance from “Lisa in the Health Library”‘s blogpost here: https://lisainthehealthlibrary.wordpress.com/2014/05/05/creating-google-maps-from-postcode-data/ and completed the mapping.
Onwards with the powershell quest, this code queries the remote computer named “PC1” for installed software and writes the results to a local file “C:\PC1_InstalledPrograms.csv”. The ouput is filtered for the “Displayname”,”Publisher”,”Version” and sorted by DisplayName.
Note: it does require SCCM’s Software Centre installed I think!
PS C:\Windows\system32> get-wmiobject -class win32reg_addremoveprograms -computername PC1 | select-object Displayname,Publisher,Version | export-csv -path "c:\PC1.csv"