1E Shopping Database : Query to find application enabled or disabled on Shopping Get link Facebook Twitter Pinterest Email Other Apps By San - September 21, 2014 select * from tb_Application select * from tb_Application where Enabled = 1 select * from tb_Application where Enabled = 0 Get link Facebook Twitter Pinterest Email Other Apps Comments
SCCM SQL Query : To List Machines With IIS , FTP Or Telnet Installed By San - September 21, 2014 Select SD.Name0 ‘Machine Name’, SD.Operating_System_Name_and0 NOS, SS.Name0 ‘Service Name’, SS.DisplayName0 ‘Display Name’, SS.StartMode0 ‘Start Type’, SS.Started0 Started, SS.State0 State, SS.Status0 Status From System_DISC SD Join Services_DATA SS on SS.MachineID = SD.ItemKey Where SS.Name0 In (‘W3SVC’, ‘MsFtpSvc’, ‘TlntSvr’) Order By ‘Machine Name’ Read more
SCCM SQL Query : To Gather Video Card Memory Information By San - September 21, 2014 Select SD.Name0 ‘Machine Name’, VC.Name0 ‘Video Card’, Convert(VarChar, VC.AdapterRam0 / 1024) + ‘ MB’ From v_R_System SD Join v_Gs_Video_Controller VC on SD.ResourceID = VC.ResourceID Where VC.Name0 <> ‘ConfigMgr Remote Control Driver’ Order By SD.Name0 Read more
SCCM SQL Query : To Get Members Of A Specified Collection By San - September 21, 2014 Select Members.Name ‘Collection Members:’ From CollectionMembers Members Join Collections Coll on Members.SiteID = Coll.SiteID Where Coll.CollectionName = ‘All Systems’ Read more
Comments
Post a Comment