If you have a custom field that only accepts values from a lookup table, you cannot assign values the way you would with a regular custom field value. To start we will retrieve the ‘InternalName‘ property of the custom field, the value should look like the variable ‘customFieldInternalName‘ below.
I created a Powershell script to generate an Excel report for a client which is run by the task scheduler on Windows Server 2012 R2. When I executed the Powershell script manually the Excel file would save successfully and the Excel process exits. When the same script is ran using the task scheduler, the Excel process opens, Powershell script finishes, and the Excel process remains open forever and it will never save the file.
It took me some time to figure out. But I finally managed to get the right things together. Some sources stated that it is impossible to do this with Powershell, because it supposedly doesn’t support TLS. Apparently, the current Powershell version supports SSL/TLS. There were various templates on the internet that saved the encrypted password in a file. Which is a safer method than storing the password in the Powershell script file. I wanted to show you how to do this without much hassle.
It took me several weeks to figure this out. When updating a project, you would usually check it out manually and then check it back in and publish when you are done. Then you wait for the PWA job queue to finish the job you submitted. This is quite easy to write in C#.
When you have Project Server Online, you have several types of licenses you can assign to your users. If you assign Project Professional licenses to employees that generally don’t require it, you will end up wasting a lot of money.
Little more than a month ago, I wrote about the different authentication used in Project Server & SharePoint for on-premises and SharePoint Online & Project Server.
A client of mine regularly wanted to see a report of all users and the licenses that are assigned to them. I decided to write a script to save me and my client time. Feel free to re-use, modify and share my script and guide.