jbmurphy.com

Author: jbmurphy

  • When using PowerShell to pull REST data from MS CRM, escape `$filter !

    Note to self. When trying to filter a REST response in PowerShell, by using the “$filter” parameter in the url (as with MS CRM 2011), you must escape the “$” with “`$”. For example: Does not work: $url=”http://crmserver.company.com/Organization/xrmservices/2011/OrganizationData.svc/ContactSet$filter=StateCode/Value eq 0″ Works: $url=”http://crmserver.company.com/Organization/xrmservices/2011/OrganizationData.svc/ContactSet`$filter=StateCode/Value eq 0″ Gets me every time, and I can’t figure out why my…

  • Microsoft Certified Solutions Expert: Cloud Platform and Infrastructure

    I just became a Microsoft Certified Solutions Expert: Cloud Platform and Infrastructure (MCSE) ! I haven’t taken any new exams in over a year – I guess I already had enough of the requirements ! Nice?

  • Using jsforce and node.js to connect to Salesforce

    I wanted to write a node.js app to pull data from Salesforce. I found the NPM library jsforce. I added it to my packages in my package.json: I also added “dotenv” which I am using to load my client secret and all configuration data from a hidden .env file. This is not in my git…

  • Extract ADFS signing certificate from the Federation Metadat URL

    I did not write this, but I liked it, so I thought I would pass it on! Use this script to extract the ADFS signing certificate from the FederationMetadat url (https://sts.yourserver.com/FederationMetadata/2007-06/FederationMetadata.xml): https://raw.githubusercontent.com/bergie/passport-saml/master/docs/adfs/retrieve_adfs_certificate.sh

  • My script/procedure to move Hyper-V VMs to Azure

    We have been moving resources from ESXi to Hyper-V to Azure. ESXi to Hyper-V is done via the Microsoft Virtual Machine Converter (MVMC). Here is the Checklist/Script/Procedure I have been using to get Hyper-V to Azure. Once machine is in Hyper-V, make sure the VMs HDs are VHD and not VHDX Make sure DHCP is…

  • Using Let’s Encrypt, cerbot-auto with Apache on CentOS 6

    There are plenty of better documented examples out there, so this is more of a note to self. The name on the cert will be the first domain you list int he command above. All the other names will be part of the SAN cert. And to renew, cron this up: /opt/YourDir/certbot-auto renew

  • Using ADFS for authenticating apache hosted sites

    I have been learning ADFS/SAML on the fly. If you come across this, and you see that I am doing it all wrong, then let me know! I wanted to use my existing ADFS infrastructure to authenticate an apache resource on CentOS 6. Below is what I figured out (There are alot of steps). First,…

  • Problems with Citrix Receiver over VPN: ARGetNetworkLocationForStore returned NETWORK_LOCATION_NONE

    I was working on my home lab, specifically setting up a Citrix XenDesktop environment. Since I didn’t have a Netscaler in place (yet), I connected to my home network via a Cisco AnyConnect VPN via a Mac. While tunneling through the VPN connection, I could connect to the storefront and resources via HTML5, but I…

  • Connecting to the Salesforce REST api using PowerShell

    As I said in my previous post, we are starting to use Salesforce, and I like REST APIs, so I wanted to see how to connect to Salesforce with cuRL and PowerShell. cURL was pretty easy, PowerShell was not so much. The biggest issue was that when I queried the standard “https://login.salesforce.com/services/oauth2/token” url, I would…

  • Connecting to the Salesforce REST api using cURL

    My company decided to use Salesforce. I have worked with Microsoft CRM, but not Salesforce yet. When learning about a new application, I like to see how I can access the data. PowerShell and cURL are the simplest way for me to understand how to connect to a REST api. First step is getting an…