Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  query
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 ...
    on5 Sep 2013

  • 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...
    on1 Aug 2013

  • 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 ...
    on26 Jun 2013

  • 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...
    on30 May 2013

  • 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...
    on7 May 2013

  • 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...
    on27 Oct 2012

  • Wiki Page: SQL Server 2012 での空間ポイントデータクエリのチューニング (ja-JP)

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

  • 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...
    on26 Feb 2012
Page 1 of 1 (8 items)
Can't find it? Write it!

Post an Article