Links/Aliases to everything Number2
SMS Permissions - BITWISE "AND" with a PIVOT thrown in for pretty :)
Use data outside the SMS DB in your SMS Web Reports
Script to export SMS Web report results to an Excel spreadsheet
Script to export SMS Web report results to a CSV file
THE PROBLEM
SMS Web Reports - Passing a delimited list to SMS Web Reports like a table - (also convert list to rows in SQL)
How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx
THE PROBLEM
Outlook machine counts by version (Plus a trick to order by version PROPERLY)
Showing posts with label sms. Show all posts
Showing posts with label sms. Show all posts
Tuesday, July 1, 2008
Thursday, February 28, 2008
Tuesday, February 19, 2008
Tuesday, February 12, 2008
GalaXQL - Interactive SQL tutorial
GalaXQL - Interactive SQL tutorial
Who said SQL tutorials have to be boring?
WQL to SQL
This SQL Query can be used to see how WQL is converted to SQL by SMS for collections.
SelectCollections.SiteID, Collections.CollectionName, Collection_Rules.QueryName, Collection_Rules_SQL.WQL, Collection_Rules_SQL.SQL From Collections,Collection_Rules, Collection_Rules_SQLWhere Collections.CollectionID = Collection_Rules.CollectionIDAND Collections.CollectionID = Collection_Rules_SQL.CollectionID
Who said SQL tutorials have to be boring?
WQL to SQL
This SQL Query can be used to see how WQL is converted to SQL by SMS for collections.
SelectCollections.SiteID, Collections.CollectionName, Collection_Rules.QueryName, Collection_Rules_SQL.WQL, Collection_Rules_SQL.SQL From Collections,Collection_Rules, Collection_Rules_SQLWhere Collections.CollectionID = Collection_Rules.CollectionIDAND Collections.CollectionID = Collection_Rules_SQL.CollectionID
Friday, December 21, 2007
Friday, October 19, 2007
myITforum_sms scripts
Query for machine with no logged on user for 30
may need to change the quotes around the numbers to single to get it to
quote:select SYS.Netbios_Name0, SYS.AD_Site_Name0, OS.LastBootUpTime0, WS.LastHWScan as 'Last Reported to SMS' from v_GS_Operating_System OS join v_r_system SYS on OS.ResourceID=SYS.ResourceID join v_gs_workstation_status ws on sys.resourceid=ws.resourceid Where OS.Version0 = '5.1.2600' and datediff(day,ws.LastHWScan,getdate()) < "2" and datediff(day,OS.LastBootUpTime0,getdate()) > "14" Order by SYS.AD_Site_Name0, OS.LastBootUpTime0
anyone have a vbs to edit registry key and push out wit...
sms client health script
sms sql help
Distributing a file from a central location overnight -
Simple way to identify/correct duplicate machines in co...
How to troubleshoot SMS Administrator console connectivity
gather the information contained in the local workstation’s “Administrators” group.
may need to change the quotes around the numbers to single to get it to
quote:select SYS.Netbios_Name0, SYS.AD_Site_Name0, OS.LastBootUpTime0, WS.LastHWScan as 'Last Reported to SMS' from v_GS_Operating_System OS join v_r_system SYS on OS.ResourceID=SYS.ResourceID join v_gs_workstation_status ws on sys.resourceid=ws.resourceid Where OS.Version0 = '5.1.2600' and datediff(day,ws.LastHWScan,getdate()) < "2" and datediff(day,OS.LastBootUpTime0,getdate()) > "14" Order by SYS.AD_Site_Name0, OS.LastBootUpTime0
anyone have a vbs to edit registry key and push out wit...
sms client health script
sms sql help
Distributing a file from a central location overnight -
Simple way to identify/correct duplicate machines in co...
How to troubleshoot SMS Administrator console connectivity
gather the information contained in the local workstation’s “Administrators” group.
Tuesday, August 14, 2007
Creating Altiris or Microsoft Web Reports Queries
1. Create a functional query in SMS MMC to return desired data.
2. Start SQL profiler & create a new trace... add the SMS_Provider component.
3. Run the SMS query in MMC - Profiler captures actual SQL code issued via SMS_PROVIDER.
4. Copy SELECT statement from Profiler's Trace tool.
5. Paste SQL statement into SQL Query Analyzer as a new query
6. Do a little SQL syntax cleanup in Analyzer... SMS Profiler captures SQL statement's values using double-quotes; Query Analyzer requires single-quotes... edit where necessary (tip: When you parse the query in Analyzer, it'll return a syntax error referencing the first occurrence of the offending text - look for that text in the statement & you'll find the double-quotes, displayed in gray. Replace the double quotes with single, and the value will change to red text, indicating correct syntax).
from http://www.myitforum.com/articles/5/view.asp?id=190
2. Start SQL profiler & create a new trace... add the SMS_Provider component.
3. Run the SMS query in MMC - Profiler captures actual SQL code issued via SMS_PROVIDER.
4. Copy SELECT statement from Profiler's Trace tool.
5. Paste SQL statement into SQL Query Analyzer as a new query
6. Do a little SQL syntax cleanup in Analyzer... SMS Profiler captures SQL statement's values using double-quotes; Query Analyzer requires single-quotes... edit where necessary (tip: When you parse the query in Analyzer, it'll return a syntax error referencing the first occurrence of the offending text - look for that text in the statement & you'll find the double-quotes, displayed in gray. Replace the double quotes with single, and the value will change to red text, indicating correct syntax).
from http://www.myitforum.com/articles/5/view.asp?id=190
Saturday, July 28, 2007
spicWorks
spiceWorks
Introducing the free Spiceworks IT Desktop.
Designed, tested and used by 100,000 IT pros in 185 countries. Spiceworks has the everyday IT features you need:
Inventory and report on your company's hardware and software assets automatically.
Monitor and troubleshoot the hardware and software on your network.
Run an IT Help Desk for your company that's easy to use.
It takes less than 5 minutes to get up and running. No agents. No scripts. No manual. No hassles. Just download Spiceworks and go.
And, Spiceworks is really free. No trials. No time or device limits. Simply free. All thanks to sponsorships by top technology vendors.
Freedom is just a download away.
Introducing the free Spiceworks IT Desktop.
Designed, tested and used by 100,000 IT pros in 185 countries. Spiceworks has the everyday IT features you need:
Inventory and report on your company's hardware and software assets automatically.
Monitor and troubleshoot the hardware and software on your network.
Run an IT Help Desk for your company that's easy to use.
It takes less than 5 minutes to get up and running. No agents. No scripts. No manual. No hassles. Just download Spiceworks and go.
And, Spiceworks is really free. No trials. No time or device limits. Simply free. All thanks to sponsorships by top technology vendors.
Freedom is just a download away.
Wednesday, July 25, 2007
Monday, July 23, 2007
Microsoft IT Site Delete Capture 1.0
Microsoft IT Site Delete Capture 1.0
If you ever have end users or end-losers as I have sometimes referred to them as in fits of anger that have the ability to delete sites and actually do so then this utility is for you. The utility works by taking the site(s) that are deleted using the event model and captures them by backing them up to disk so that they can be restored.
Microsoft IT Site Delete Capture 1.0
http://www.codeplex.com/governance/Release/ProjectReleases.aspx?ReleaseId=3830
from don hite
If you ever have end users or end-losers as I have sometimes referred to them as in fits of anger that have the ability to delete sites and actually do so then this utility is for you. The utility works by taking the site(s) that are deleted using the event model and captures them by backing them up to disk so that they can be restored.
Microsoft IT Site Delete Capture 1.0
http://www.codeplex.com/governance/Release/ProjectReleases.aspx?ReleaseId=3830
from don hite
Wednesday, July 18, 2007
Locating Machines Not Reporting Heartbeat Discovery In The Last
Locating Machines Not Reporting Heartbeat Discovery In The Last Week - Don Hite
This SQL query will allow you to find or locate machines in your SMS database that have not reported a Heartbeat discovery record in the last week or seven days.
SQL Query:
Select
SD.Netbios_Name0,
A.AgentName,
DI.AgentTime
From System_Disc SD
Inner Join DiscItemAgents DI on SD.DiscArchKey = DI.DiscArchKey
Cross Join Agents A
Where A.AgentName = 'Heartbeat Discovery'
And DatePart (D,DI.AgentTime) >= 7
This SQL query will allow you to find or locate machines in your SMS database that have not reported a Heartbeat discovery record in the last week or seven days.
SQL Query:
Select
SD.Netbios_Name0,
A.AgentName,
DI.AgentTime
From System_Disc SD
Inner Join DiscItemAgents DI on SD.DiscArchKey = DI.DiscArchKey
Cross Join Agents A
Where A.AgentName = 'Heartbeat Discovery'
And DatePart (D,DI.AgentTime) >= 7
Subscribe to:
Posts (Atom)