SCCM Reports

SCCM 2007 / SMS 2003 SQL Package Related Query

by

———————————————————————————————————————————–SQL Query:–>———————————————————————————————————————————– To know the package Name and ID SELECT     PackageID, NameFROM         dbo.v_Package———————————————————————————————————————————– ———————————————————————————————————————————–SQL Query:–> If you want to filter with the package ID then modify the Query to SELECT     PackageID, NameFROM         dbo.v_PackageWHERE     (PackageID = 'YourPKGID') ———————————————————————————————————————————–——————-Thanks,https://sccm07.blogspot.com/

This was a basic overview of the ‘for’ command

by

This was a basic overview of the ‘for’ command This is the first in a series of posts containing information on what I consider the building blocks to automate repetitive tasks at the Windows command-line. These components are the for, find, findstr, set, if and echo commands, control files used for data input, combined with … Read more

Find the URLs of the currently running Internext Explorer Windows

by

' VBScript' Find the URLs of the currently running Internext Explorer Windows ' References:'  https://windowssdk.msdn.microsoft.com/en-us/library/ms630310.aspx'  https://msdn.microsoft.com/library/default.asp?url=/workshop/browser/webbrowser/reference/objects/internetexplorer.asp Const IE_EXE = "iexplore.exe" Call FindCurrentURLs(strURLSet)WScript.Echo strURLSet wscript.quit(0) Function FindCurrentURLs(ByRef strURLSet) Dim objShell, objWindowSet, objWindow Dim strwindowName, strURL, strFullName  Set objShell = CreateObject("Shell.Application")    ' Create a Windows shell automation object Set objWindowSet = objShell.Windows      ' Get the collection of open windows belonging … Read more

Enumerating URLs in Internet Explorer

by

Enumerating URLs in Internet Explorer   # PowerShell $shell = new-object –com Shell.Application $windows = $shell.Windows() write-output ($windows.count.ToString() + " windows found") foreach ($window in $windows) {  if ($window.FullName -like "*iexplore*") {    write-output ($window.LocationURL + ", " + $window.LocationName)  }} $shell = $null ' VBScript' Find the URLs of the currently running Internext Explorer Windows … Read more

SMS / SCCM Web Reports Error 500

by

Large SMS Web Reports return Error 500 When executing large SMS report queries with thousands of rows from an SMS reporting server running on Windows Server 2003 with IIS 6.0, a HTTP 500 error may be returned. This post describes the ASP buffer overflow error that can occur and how to resolve the issue. After … Read more

Some Active Directory commands

by

Some Active Directory commands The commands below are a subset of the complete command list found in Useful command-lines, and are command-line operations that perform queries, diagnostics or modifications to objects in an Active Directory. These commands can be useful for once-off or repeated tasks, and defining a source for bulk imports/modifications to objects. Each … Read more

SQL 2008 TechNet Webcasts

by

SQL 2008 TechNet Webcasts   Provided here are links to Microsoft TechNet SQL 2008 Webcasts available in Windows Media Player (WMA), Zune and MP3 format.   SQL-300 What's New In Microsoft SQL 2008 In this session, we will go through an overview tour of the new features of SQL Server 2008, split into four core … Read more

SMS / SCCM Cleint health find Script

by

here is the Batch file script for SCCM / SMS Clients health along with Last hardware scan report sent time and lastheartbeat time stamp it will show you in the command window this will help you to know the status of Client agent.   ==================================================================================== @echo off@echo Client Version  Last Hardware Inventory  Hours Since Last HINVosql.exe -S … Read more