SQL Queries Archives | Page 4 Of 7

Creating 1000 User Accounts

August 4, 2009 by PaddyMaddy

———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————– –Creating 1000 User Accounts Set objRootDSE = GetObject("LDAP://rootDSE")Set objContainer = GetObject("LDAP://cn=Users," & _ objRootDSE.Get("defaultNamingContext")) For i = 1 To 1000 Set objLeaf = objContainer.Create("User", "cn=UserNo" & i) objLeaf.Put "sAMAccountName", "UserNo" & i objLeaf.SetInfoNext WScript.Echo "1000 Users created." ———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————–—-Creating an Active Directory User Account————————————————————————- Creates a user account in Active … Read more

Using VBScript to PLAY with Active Directory

December 23, 2019August 4, 2009 by PaddyMaddy

Using VBScript to Export All Objects in the Marketing OU In this example, you use a text editor such as Notepad to create a VBScript program. The script searches the Marketing OU and creates a text file that lists all of the user objects and a subset of their attributes. To create the export script … Read more

Enable File and Printer Sharing Through Windows Firewall

December 23, 2019May 29, 2009 by PaddyMaddy

Set objFirewall = CreateObject("HNetCfg.FwMgr")Set objPolicy = objFirewall.LocalPolicy.CurrentProfile Set colServices = objPolicy.ServicesSet objService = colServices.Item(0)objService.Enabled = TRUE ——————-Thanks,https://sccm07.blogspot.com/

Excelent Artical for WMI Troubleshooting Tips

December 23, 2019May 27, 2009 by PaddyMaddy

WMI Troubleshooting Tips https://blogs.technet.com/configmgrteam/archive/2009/05/08/wmi-troubleshooting-tips.aspx ——————-Thanks,https://sccm07.blogspot.com/

Feature Comparison of MSDE and SQL Server 2005 Express

December 23, 2019April 2, 2009 by PaddyMaddy

Feature Comparison of MSDE and SQL Server 2005 Express While the core database capabilities of MSDE and SQL Server 2005 Express are similar, the set of features and database capabilities of MSDE and SQL Server 2005 Express are different. The following table provides a feature comparison between MSDE and SQL Server 2005 Express. Feature MSDE … Read more

SCCM 2007 with SQL Server 2005 Reporting Services

December 23, 2019March 18, 2009 by PaddyMaddy

SCCM 2007 with SQL Server 2005 Reporting Services Listen to Adam's podcast on these rules with Greg Low Duration: 50 minutes 39 secondsSize: 14.5MB Watch Adam's video on DNRTV on these rules: Part A (53:13) – 181MBPart B (49:12) – 171MB Part C (42:19) – 158MB Complete covarage can be found in … Read more

SQL Tables For accurate licence info

December 23, 2019March 12, 2009 by PaddyMaddy

For accurate licence select * from V_R_System_valid select * from dbo.v_LU_MSProd Select * from dbo.v_GS_INSTALLED_SOFTWARE ——————-Thanks,https://sccm07.blogspot.com/

FIND SQL Server Version with SQL Query

December 23, 2019March 3, 2009 by PaddyMaddy

SELECT LTRIM(RIGHT(LEFT(@@VERSION,38),9)) SELECT 'SQL Server ' + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' – ' + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')' ——————-Thanks,https://sccm07.blogspot.com/

WQL to SQL Query

December 23, 2019February 20, 2009 by PaddyMaddy

WQL to SQL Want to see What is the query???????? This SQL Query can be used to see how WQL is converted to SQL by SMS for collections Select Collections.SiteID , Collections.CollectionName , Collection_Rules.QueryName , Collection_Rules_SQL.WQL , Collection_Rules_SQL.SQL From Collections,Collection_Rules, Collection_Rules_SQL Where Collections.CollectionID = Collection_Rules.CollectionID AND Collections.CollectionID = Collection_Rules_SQL.CollectionID——————- Thanks,https://sccm07.blogspot.com/

SCCM Query for SCCM Clients Model and Manufactures Name

December 23, 2019February 4, 2009 by PaddyMaddy

Need to extract SCCM Clients Model and Manufactures Name? You have to dig the Computer_System_DATA Table. Here are two shared SQL Querys. Select DISTINCT Model0 from Computer_System_DATA The above one will show all the Models The below Query will show everything in the Database Select * from Computer_system_data ——————-Thanks,https://sccm07.blogspot.com/