Browse by Tags

Tagged Content List
  • Wiki Page: ConfigMgr : Query to find all non-client and unassigned machines (computers and servers)

    Just create a collection and use the following query : select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where Client = 0 or Client is NULL and ...
  • Wiki Page: Active Directory: Querying User Accounts

    Various scripting and command-line methods for querying Active Directory for a list of users. Table of Contents Directory Services DSQuery User DSGet User DSQuery * VBScript PowerShell ADSI Active Directory module Quest ActiveRoles snapin Directory Services DSQuery User Query a...
  • Wiki Page: Querying WMI

    Here are some examples of how to query WMI via cmdline/scripting. Table of Contents WMIC VBScript PowerShell WMIC Retrieve all properties related to the Operating System class wmic OS Retrieve the Version property of the Operaring System class wmic OS get Version ...
  • Wiki Page: Entity Framework FAQ: Querying

    Table of Contents General LINQ Questions How do I retrieve a single entity? How does "Include" work with multiple levels of branches? How do I query trees using LINQ? Entity Framework Related LINQ Questions Can I execute queries locally rather than at the database? Is data filtered on the database...
  • Wiki Page: SharePoint Server 2010 Search

    SharePoint Server 2010 search includes new features and a new architecture that enables a more scalable topology. Search capability continues to be pervasive and integrates very well with the new social networking features. The new architecture scales to approximately 100 million items, and search...
  • Wiki Page: Tuning Spatial Point Data Queries in SQL Server 2012

    Tuning Spatial Point Data Queries in SQL Server 2012 Written by: Ed Katibah, Milan Stojic, Michael Rys, Nicholas Dritsas Technical reviewers: Chuck Heinzelman Introduction Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application...
  • Wiki Page: SQL Server 2012 での空間ポイントデータクエリのチューニング (ja-JP)

    Table of Contents 紹介 主キーのクラスター化インデックス最適化 空間インデックスの基本 空間インデックスの最適化 geography データ型を使用する場合に、球体地球モデルを利用することの考慮 パフォーマンステスト 結論 他の言語 SQL Server 2012 での空間ポイントデータクエリのチューニング 執筆者: Ed Katibah, Milan Stojic, Michael Rys, Nicholas Dritsas テクニカルレビュアー: Chuck Heinzelman 紹介 空間ポイントデータクエリでは、パフォーマンスを向上し...
  • Wiki Page: ConfigMgr (SCCM) – SLP-MP Health Check Script

    I would like to share a very useful script to check the availability/functionality of Management Point (MP) and Server Locator Point (SLP) in a ConfigMgr environment. Download the script from HERE Usage SLP-MP Health Check Script can be scheduled to run automatically with no user intervention...
Page 1 of 1 (8 items)
Can't find it? Write it!