Tips & Tricks
Remote SQL Server with a Named Instance
As Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) administrator we wear many hats. One of those hats is SQL Server administration. We use SQL for several components within ConfigMgr including ConfigMgr, WSUS and SQL Server Reporting...
Remote SQL Server with a Non-Default Port
Sometimes people want to make life difficult for themselves. SQL deployments in a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) environment come to mind. In one such example, deploying a remote SQL installation with a default instance name...
“Invalid object name” in SSMS
As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) administrator We are not always well verse with SQL Server and its errors. Particularly within SQL Server Management Studio (SSMS). In this Article and video, we will show you how to...
Friday Funny–Meet Jack
This is guest post from Suzanne who is the Senior Developer at Enhansoft. At Enhansoft, asset inventory and reporting is the name of the game! We are Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM ) Inventory and reporting specialist. So, to go along...
Remotely Determine the SMS Provider Using WBEMTest v2
This is a guess blog post from Suzanne, who works as the Senior Developer at Enhansoft. As I was reading Garth Jones’ blog post on how to remotely determine the SMS Provider using WBEMTest. Microsoft Endpoint Manager Configuration Manager (MEMCM / MECM / SCCM) uses...
Remotely Determine the SMS Provider Using WBEMTest
In this blog post, I will show you the steps to use in order to locate the SMS provider manually. From time to time, one of the questions we hear is: How can I determine what my SMS_provider path/name is? This is important to know because if you do any System Center...
VM Collections!
While reading a Reddit, I ran across a post WQL Query SCCM. Originally the post was listed in another language, I forget which one as it is not important. After some back and forth, I understand they he wanted to create a collection of VM host. In this article I will...
VM Collections!
While reading a Reddit, I ran across a post WQL Query SCCM. Originally the post was listed in another language, I forget which one as it is not important. After some back and forth, I understand they he wanted to create a collection of VM host. In this article I will...
Enhancing GetColor to add Defined Colors
While creating the videos for the GetColor updates. It dawned on me that I should show you how to Enhancing GetColor to add Defined Colors. To do this, I will show you how to define colors for a particular string value using the GetColor function. DEFINE COLORS Before...
How to Create a Visual Filter in Power BI
Hi Everyone! Today I am talking about How to create a visual filter in Power BI and how to set them up. This post is part of a series of blog posts that we’ve done at Enhansoft about the different types of Power BI filters. Visual filter are useful for refining...