KAPes musings !

Archive for September, 2009

Scripts and Files of the Inside Active Directory book

Posted by kapes on September 30, 2009

Inside Active Directory contains over 60 sample scripts written in VBScript, as well as some LDIF, batch, and Excel files.

Posted in Uncategorized | Tagged: | Leave a Comment »

Complete list of TED Talks

Posted by kapes on September 30, 2009

TEDTalks Complete List.

TED is an annual conference about “ideas worth spreading.”  A lot of famous people present at TED — Bill Clinton, Bill Gates, Al Gore, Tony Robbins, and so on — but there are also many  less-well-known presenters — such as scientists, engineers, economists, directors, entrepreneurs, and artists — who are doing amazing work around the world.

Almost all the presentations that have been given over the years at TED are available for free viewing at the TED website. Each talk is about 15 minutes long, which make them perfect for watching during a break in the day. The video quality is excellent, and many of the talks have been translated into other languages.

Google spreadsheet is a  great way to browse the topics. When you find one you like, just click the link and it will take you to the TED site.)

Posted in Uncategorized | Tagged: , | Leave a Comment »

Coding Horror: 9 Ways Marketing Weasels Will Try to Manipulate You

Posted by kapes on September 30, 2009

Very insightful commentary on irrational nature of humans. I am definitely buying that book.

Posted in Uncategorized | Tagged: | Leave a Comment »

WSUS Client Inventory

Posted by kapes on September 14, 2009

Download and install Microsoft SQL Server Management Studio Express on your WSUS 3 Server
Use Windows Authentication to connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Then run following query locally from WSUS server.

SELECT [Name]
,[IPAddress]
,[LastSyncResult]
,[LastSyncTime]
,[LastReportedStatusTime]
,[OSArchitecture]
,[Make]
,[Model]
,[BiosName]
,[BiosVersion]
,[BiosReleaseDate]
,[OSMajorVersion]
,[OSMinorVersion]
,[OSBuildNumber]
,[OSServicePackMajorNumber]
,[OSDefaultUILanguage]
FROM [SUSDB].[PUBLIC_VIEWS].[vComputerTarget]

if you are command line junkie use SQLCMD.exe

Prerequisite is : SQL Native client

Posted in SQL-Query, WSUS | Leave a Comment »

List all sites and relevant subnets and domain controllers

Posted by kapes on September 11, 2009

To list all site names

dsquery site -o rdn -limit 0 > all.sites.txt

To get all associated subnets (all.sites.txt from above command is required)

for /F %A in (all.sites.txt) do For /F %X in (‘dsquery subnet -site %A -o rdn’) do echo %A,%X >> sites.subnets.csv

To get all associated domain controllers (all.sites.txt from above command is required)

for /F %A in (all.sites.txt) do For /F %X in (‘dsquery server -site %A -o rdn’) do echo %A,%X >> sites.Servers.csv

Posted in Uncategorized | Tagged: , | Leave a Comment »

Email to SMS Gateways, Complete List

Posted by kapes on September 9, 2009

Email to SMS Gateways, Complete List | mutube.

Specifically for US

n@teleflip.com Teleflip
n@message.alltel.com Alltel
n@paging.acswireless.com Ameritech
n@txt.att.net ATT Wireless
n@bellsouth.cl Bellsouth
n@myboostmobile.com Boost
n@mobile.celloneusa.com CellularOne
n@mms.uscc.net CellularOne MMS
1n@mobile.mycingular.com Cingular
n@sms.edgewireless.com Edge Wireless
n@messaging.sprintpcs.com Sprint PCS
n@tmomail.net T-Mobile
n@mymetropcs.com Metro PCS
n@messaging.nextel.com Nextel
n@mobile.celloneusa.com O2
n@mobile.celloneusa.com Orange
n@qwestmp.com Qwest
n@pcs.rogers.com Rogers Wireless
n@msg.telus.com Telus Mobility
n@email.uscc.net US Cellular
n@vtext.com Verizon
n@vmobl.com Virgin Mobile

Posted in Uncategorized | Tagged: | Leave a Comment »

Understanding the MOSS containment hieararchy

Posted by kapes on September 3, 2009

Brian Wilson : Understanding the Microsoft Office SharePoint Server 2007 containment hierarchy to design efficient information architectures.

A very good high level overview of MOSS.

Posted in Uncategorized | Tagged: | Leave a Comment »

ASP.NET Required Access Control Lists (ACLs)

Posted by kapes on September 2, 2009

ASP.NET Required Access Control Lists (ACLs)

Type of file and folder permissions the identity of an ASP.NET Web application must have in order to function properly.

Posted in Programming | Tagged: | Leave a Comment »

Lots of VERY useful SQL queries for MOM 2005

Posted by kapes on September 2, 2009

http://blogs.technet.com/kevinholman/archive/2007/10/18/useful-mom-2005-sql-queries.aspx

  • Queries to find out how old present data
  • Grooming the SCDW
  • Query to examine the last groom job and how long it took in the SCDW
  • Running the DTS job with latency
  • Faking the Onepoint database to think DTS is working in order to groom
  • Most common alerts in a Onepoint DB
  • To determine computers that are generating the most event data
  • To display the most common perf insertions

You get the idea 🙂

Posted in MOM-2005, Programming, SQL-Query | Tagged: , | Leave a Comment »

WSUS Approval History Report

Posted by kapes on September 2, 2009

SELECT UT.DefaultTitle as [Title]

,UT.DefaultDescription as [Description]

,[MsrcSeverity]

,[KnowledgebaseArticle] as [KB]

,[SecurityBulletin]

,[PublicationState]

,[UpdateType]

,[InstallationRebootBehavior]

,[ArrivalDate]

,[Action]

,[Deadline]

,UA.[CreationDate] as [Approved On]

,[AdministratorName] as [Approved By]

FROM [SUSDB].[PUBLIC_VIEWS].[vUpdateApproval] as UA left join [SUSDB].[PUBLIC_VIEWS].[vUpdate] as UT on UA.UpdateID = ut.UPDATeID

Where AdministratorName <> ‘WUS Server’

order by [Approved On]

Posted in SQL-Query, WSUS | Tagged: , | Leave a Comment »