SharePoint Tip of the Day – Who is the LocalSystem account used to run the Administration Service (SPAdminV4) ?


Localsystemaccount

Even on least privileges installation of your farm, the SPAdminV4 services will run under the Local System account (be sure to read this reference table : http://nikspatel.wordpress.com/2010/12/24/sharepoint-2010-service-account-references-for-least-privileged-installation/ and this – for SP 2007 but still as valid for 2010 / 2013 : http://technet.microsoft.com/en-us/library/cc288210%28v=office.12%29.aspx) but ‘who’ is this built-in account ?

The LocalSystem account has extensive privileges on the local computer, and acts as the computer on the network. Its token includes the NT AUTHORITYSYSTEM and BUILTINAdministrators SIDs; these accounts have access to most system objects. The name of the account in all locales is .LocalSystem. The name, LocalSystem or ComputerNameLocalSystem can also be used. This account does not have a password.

One advantage of running under the LocalSystem account is that the service has complete unrestricted access to local resources. This is also the disadvantage of LocalSystem because a LocalSystem service can do things that would bring down the entire system

(http://msdn.microsoft.com/en-us/library/windows/desktop/ms684190%28v=vs.85%29.aspx & http://msdn.microsoft.com/en-us/library/windows/desktop/ms677973%28v=vs.85%29.aspx)

SharePoint / Excel Tip of the Day – Easily remove duplicates in your MMS csv files


Excel-duplicates-finder

Whenever working with huge term sets, you can hardly avoid having duplicates. Even if an import will skip them, if you process them programmatically (eg: PowerShell import & processing) it’s better & easier to work on a proper set than always checking for duplicates. It’s also welcome when you send this back & forth to consumers so they can easily refine their taxonomy without missing with duplicates.

Turns out it’s pretty simple in Excel, you just highlight the area you want to filter, go to data > Filter (Advanced) you specify a region next to your current one (you can’t do this on another sheet) and you’ll have only the unique entries. Copy / paste this selection on a new document and you now have your filtered set, with only unique entries.

Hard to beat when dealing with taxonomies that have thousands of terms 🙂