Wednesday, April 20, 2011

Did you checked what is the log file of SCCM DB ? or did you checked what is the backup size and why it is increasing ?

Did you checked what is the log file of SCCM DB ? or did you checked what is the backup size and why it is increasing ?


Yes it is because of transaction log size increase … check below query to know the size of the log files….




SELECT name,size from sys.database_files


name                         size
SMS_SiteCode           662576
SMS_SiteCode_log     3541704

Monday, April 18, 2011

SQL Report with the systems Names and Architecture for specific collection

finding the systems Names and Architecture for specific collection


SELECT     dbo.v_Collection.CollectionID, dbo.v_GS_COMPUTER_SYSTEM.Name0, dbo.v_GS_COMPUTER_SYSTEM.SystemType0,
                      dbo.v_GS_COMPUTER_SYSTEM.UserName0, dbo.v_R_System.Operating_System_Name_and0
FROM         dbo.v_Collection INNER JOIN
                      dbo.v_FullCollectionMembership ON dbo.v_Collection.CollectionID = dbo.v_FullCollectionMembership.CollectionID INNER JOIN
                      dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_FullCollectionMembership.ResourceID = dbo.v_GS_COMPUTER_SYSTEM.ResourceID INNER JOIN
                      dbo.v_R_System ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID
WHERE     (dbo.v_Collection.CollectionID = 'CollectionID')

Required Patches based on collection ID

                      TOP (100) PERCENT SYS.Name0 AS [Machine Name], UCS.Status AS [Patch Status Code],
                      CASE WHEN UCS.Status = '2' THEN 'Applicable' WHEN UCS.Status = '3' THEN 'Installed' ELSE '' END AS 'Patch Status', UI.BulletinID, UI.ArticleID, UI.Title,
                      dbo.v_FullCollectionMembership.ResourceID, dbo.v_Collection.CollectionID
FROM         dbo.v_FullCollectionMembership INNER JOIN
                      dbo.v_Collection ON dbo.v_FullCollectionMembership.CollectionID = dbo.v_Collection.CollectionID INNER JOIN
                      dbo.v_R_System AS SYS LEFT OUTER JOIN
                      dbo.v_Update_ComplianceStatusAll AS UCS ON SYS.ResourceID = UCS.ResourceID INNER JOIN
                      dbo.v_UpdateInfo AS UI ON UCS.CI_ID = UI.CI_ID ON dbo.v_FullCollectionMembership.ResourceID = UCS.ResourceID
WHERE     (UCS.Status IN ('3', '2')) AND (dbo.v_Collection.CollectionID = 'CollectionID')

HOW TO: Use Wildcard Search with Various Google Services Read more:

My favorite operator is wildcard because it is able to give you most unexpected and creative results.

Here’s how you can play with it in various Google services:

General Google Search + Wildcard

General Google search allows a lot of flexibility with its wildcard operator.

How it works: * is substituted by one or more words.

When it comes particularly in handy: In combination with “” (exact match) search to control the proximity within a set phrase. This trick can turn particularly useful for content inspiration as well as for keyword research (to expand your initial query):

Google Wildcard search

You can also achieve unexpected results when using the wildcard operator in combination with other search commands. Try:

  • intext:”diabetic * diets”
  • intitle:”diabetic * diets”
  • “diabetic * diets” -food
  • etc

Other Google Search Services + Wildcard

While many people are aware of wildcard search for “Universal” / “blended” results, few users also use the wildcard operator for other types of search results. Wildcard operator is also supported by multiple search engines run by Google:

  • Google images
  • Google video and Youtube;
  • Blog search;
  • Google news;
  • Google Shopping
  • etc

How it works: * is substituted by one or more words.

When it comes particularly in handy:

Here are a few example of how the search operator can turn particularly useful:

  • Find video content inspiration; example: ["blogging * wordpress"]
  • Customize your Google News RSS feed (to use it to track your brand mentions or to monitor new opportunities); example: ["guest * post *"]
  • Expand your search to include various possible variations; for example, to track new articles by “guest author” (and thus track new guest blogging opportunities), use this query in Google Blog Search: [inpostauthor:"guest * author" OR inpostauthor:"guest author"]

Blog search + wildcard

Google Reader + Wildcard

If you are an active Google Reader user and have plenty of relevant feeds in it, take the full advantage of its search functionality.

How it works: * is substituted by one word. To get two words within your phrase, use two asterisks.

When it comes particularly in handy: Google Reader is your personal collection of relevant feeds. Using it for keyword and content inspiration may turn much more effective than using generic search results.

Google Reader search

Gmail Search + Wildcard

How it works: * is substituted by one or more words.

When it comes particularly in handy: Gmail is another useful collection of resources and links dirctly related to you, what you read and what you are subscribed to. I have once shared how Gmail search can turn a great help in your keyword and content research. With wildcard, this idea is even more effective.

A wildcard operator can also turn a great help for searching Gmail attachments: filename:google*.doc – This one filters emails to only those that have doc files attached and these files have [google] in the beginning of the name (whereas filename:*google*.doc searches for messages that have documents attached with “google” mentioned somewhere in the middle of the file name).

Here’s the example set of this search and the results it triggers:

Gmail search results

Now, go play with search results to your heart’d content!

Read more: