Browse by Tags

CODE - SQL for SMS/SCCM - How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx

This is the SQL code for THIS ARTICLE SNIPPET #2 - UDF_ITEMEXTRACT - SQL FUNCTION TO EXTRACT AN ITEM OUT OF A DELIMITED LIST -- ============================================= -- Author: John Nelson (Number2) -- Create date: 2007-05-26 -- Description: Given a delimited list, a position and a delimiter...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 11-13-2007
Filed under: SQL, SMS, SMS 2003, outlook, udf_ItemExtract, v_ProductFileInfo, INT, BIGINT, CAST, itemExtract, order by, sql 2005, v_GS_SoftwareFile, SUBSTRING, CHARINDEX, sorting, v_GS_SoftwareProduct
CODE - SMS 2003 SP2+ - Tables named DWTbl%Del getting big or growing fast

SQL CODE TO SELECT FROM OUR TABLE SIZE UDF (FROM THIS ARTICLE ) SELECT TableName, CurrentBytes FROM dbo.udf_TableTracker(DEFAULT,DEFAULT) WHERE TableName LIKE '%DWTbl%Del%' SQL CODE TO TRUNCATE JUST THOSE TABLES EXEC [sp_MSforeachtable] @COMMAND1 = 'IF ''?'' LIKE ''...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 10-15-2007
Filed under: SQL, Table size, multistatement table-valued function, UDF, sp_MSForEachTable, TRUNCATE
CODE - Track table growth (or shrinkage) with a SQL job, a table and a multistatement table-valued user defined function

CODE TO CREATE TABLESIZE TRACKING TABLE CREATE TABLE [dbo].[_SDE_TableSizeTracking]( [TimeKey] [datetime] NOT NULL, [Table_ID] [int] NOT NULL, [Table_Name] [varchar](64) NOT NULL, [Row_Count] [bigint] NOT NULL, [Reserved_Bytes] [bigint] NOT NULL, [Data_Bytes] [bigint] NOT NULL, [Index_Bytes] [bigint...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 10-12-2007
Filed under: SQL, execution plan, table scan, Table size, coalesce, multistatement table-valued function, clustered index seek, UDF, user defined functions, table variable, inline function
SMS SP3, Report 97, and Ron Crumbaker's Web tool...OH MY!

We recently ran into a problem with SMS Report number 97 that seems to be cropping up from time to time. In essence, the problem arises due to a different SQL view of Add/Remove programs data in the SQL database to account for the new 64 bit add/remove programs information now tracked by SMS in SP3....

Posted to Sean McHugh at myITforum.com (Weblog) by smchugh on 07-09-2007
Filed under: SMS, SQL, Rcrumbaker's Web Tool
SCCM 07 installing now

I mentioned that I was installing SCCM 2007 the other day . Well, in reality, I started a few minutes ago. So far, so good. I've run into a few things, but Anthony already covered them in his installation guide series . All together, it has taken about fifteen minutes to get the site up and running...

Posted to Joseph Hinkle at MyITForum.com (Weblog) by jhinkle on 05-12-2007
Filed under: System Center, SQL, Deployment
SQL Server Developer Center: SQL Server 2005 Express Edition Overview

SQL Server Developer Center: SQL Server 2005 Express Edition Overview SQL Server Express Edition, a free product based on SQL Server 2005 technology, includes the unique Application XCopy feature, and networking and security that differ from other SQL Server 2005 editions. This article discusses these...

Posted to Joseph Hinkle at MyITForum.com (Weblog) by jhinkle on 11-15-2005
Filed under: SQL
Querying additional databases with SMS Web Reporting

Sounds easy, right? That's what I thought until I whipped up a query for a new report. If you are using the SMS Client Health Monitoring Tool , you know that the default configuration is that the data is stored in a separate SQL database named SMS_Healthmon. Microsoft provides a nifty Excel spreadsheet...

Posted to Joseph Hinkle at MyITForum.com (Weblog) by jhinkle on 03-04-2005
Filed under: System Center, SQL
Subselect queries in case statements plus grouping results in SQL

Steve Thompson wrote a post about sub-select queries that brought to mind a limitation of SQL that I wasn't aware of until recently. All of our Office installations are based on the Professional MSI. We install the 'Standard' components, and add Access and Publisher if a Pro license was purchased...

Posted to Joseph Hinkle at MyITForum.com (Weblog) by jhinkle on 02-15-2008
Filed under: System Center, SQL
How do I return all records when there are no matching rows in a joined table?

Question from the myITforum list: Need some help from all you experts out there, I have created an SMS report for all machines in a particular collection, but some of the machines are logged onto by local accounts, these are not being picked up on the report as there is no entry in the v_R_User, I have...

Posted to Steve Thompson at myITforum.com (Weblog) by sthompson on 02-28-2008
Filed under: SQL Server, SQL, Reporting
How do I use a wildcard for add remove program information?

Question: What I really could use is report #96 ("Computers with specific software registered in Add Remove Programs"), that allows me to include a wildcard, so I can find not only "Adobe Acrobat 8.0.0 Professional", but "Adobe Acrobat 7.0.8 Professional", and "Adobe...

Posted to Steve Thompson at myITforum.com (Weblog) by sthompson on 03-13-2008
Filed under: SQL Server, SMS 2003, SCCM 2007, SQL, Reporting

Page 1 of 40 (398 items) 1 2 3 4 5 Next > ... Last »