<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlserver.ro/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Diverse</title><link>http://sqlserver.ro/forums/27/ShowForum.aspx</link><description /><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>Re: wmi help plsz</title><link>http://sqlserver.ro/forums/thread/2580.aspx</link><pubDate>Tue, 28 Aug 2007 10:48:08 GMT</pubDate><guid isPermaLink="false">963f3a18-65dd-4aad-905c-b785cfe1d7c7:2580</guid><dc:creator>crestinul</dc:creator><slash:comments>0</slash:comments><comments>http://sqlserver.ro/forums/thread/2580.aspx</comments><wfw:commentRss>http://sqlserver.ro/forums/commentrss.aspx?SectionID=27&amp;PostID=2580</wfw:commentRss><description>mersi o sa incerc asa.</description></item><item><title>Re: wmi help plsz</title><link>http://sqlserver.ro/forums/thread/2577.aspx</link><pubDate>Tue, 28 Aug 2007 07:10:35 GMT</pubDate><guid isPermaLink="false">963f3a18-65dd-4aad-905c-b785cfe1d7c7:2577</guid><dc:creator>B_gd_n[ ]Sahlean</dc:creator><slash:comments>0</slash:comments><comments>http://sqlserver.ro/forums/thread/2577.aspx</comments><wfw:commentRss>http://sqlserver.ro/forums/commentrss.aspx?SectionID=27&amp;PostID=2577</wfw:commentRss><description>&lt;p&gt;Editoare pentru scripturi VBS care includ facilitati WMI:&lt;/p&gt;&lt;p&gt;VbsEdit &lt;a href="http://www.vbsedit.com/" title="http://www.vbsedit.com/" target="_blank"&gt;http://www.vbsedit.com/&lt;/a&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;Script Debugger IDE &lt;a href="http://www.script-debugger.com/" title="http://www.script-debugger.com/" target="_blank"&gt;http://www.script-debugger.com/&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;WMI Tools&amp;nbsp;  from MS &lt;a href="http://www.microsoft.com/technet/scriptcenter/createit.mspx" title="http://www.microsoft.com/technet/scriptcenter/createit.mspx" target="_blank"&gt;http://www.microsoft.com/technet/scriptcenter/createit.mspx&lt;/a&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>Re: wmi help plsz</title><link>http://sqlserver.ro/forums/thread/2576.aspx</link><pubDate>Tue, 28 Aug 2007 07:04:57 GMT</pubDate><guid isPermaLink="false">963f3a18-65dd-4aad-905c-b785cfe1d7c7:2576</guid><dc:creator>B_gd_n[ ]Sahlean</dc:creator><slash:comments>0</slash:comments><comments>http://sqlserver.ro/forums/thread/2576.aspx</comments><wfw:commentRss>http://sqlserver.ro/forums/commentrss.aspx?SectionID=27&amp;PostID=2576</wfw:commentRss><description>&lt;p&gt;Cea mai simpla solutie este un script VBS care schimba modul de start a serviciului dupa care restarteaza calculatorul (stiu, e o solutie care consuma timpul):&lt;/p&gt;
&lt;p&gt;&lt;u&gt;&amp;nbsp;&lt;/u&gt;&lt;b&gt;&lt;u&gt;'Dezactivare/activare cdrom&lt;/u&gt;&lt;br&gt;computer &amp;nbsp;&amp;nbsp; &amp;nbsp;= "."&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;br&gt;serviciu&amp;nbsp;&amp;nbsp; &amp;nbsp;= "cdrom"&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;br&gt;&lt;font color="red"&gt;modstart&amp;nbsp;&amp;nbsp; &amp;nbsp;= "Disabled"&amp;nbsp;&amp;nbsp; &amp;nbsp;' Disabled=dezactivare sau Automatic=activare&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;/font&gt;&lt;br&gt;&lt;br&gt;Set oInstance &amp;nbsp;&amp;nbsp; &amp;nbsp;= GetObject("winmgmts:{impersonationLevel=impersonate}//" &amp;amp; computer &amp;amp; _&lt;br&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;"/root/cimv2:Win32_Service=" &amp;amp; Chr(34) &amp;amp; serviciu &amp;amp; Chr(34))&lt;br&gt;&lt;br&gt;rez &amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;= oInstance.ChangeStartMode(modstart)&lt;br&gt;text&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;= "OK"&lt;br&gt;If rez &amp;lt;&amp;gt; 0 Then text = "esec"&lt;br&gt;WScript.Echo "Rezultat ChangeStartMode: " &amp;amp; text&lt;br&gt;&lt;br&gt;WScript.Echo "URMEAZA RESTART !"&lt;br&gt;&lt;br&gt;&lt;u&gt;'Restart &lt;/u&gt;&lt;br&gt;forteazarestart&amp;nbsp;&amp;nbsp; &amp;nbsp;= 6 &lt;br&gt;Set oOS = GetObject("winmgmts:{(Shutdown)}").ExecQuery("Select * from Win32_OperatingSystem")&lt;br&gt;For Each oOperatingSystem in oOS&lt;br&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;oOperatingSystem.Win32Shutdown(forteazarestart)&lt;br&gt;Next&lt;/b&gt;&lt;br&gt;&lt;br&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>Re: wmi help plsz</title><link>http://sqlserver.ro/forums/thread/2571.aspx</link><pubDate>Mon, 27 Aug 2007 16:42:05 GMT</pubDate><guid isPermaLink="false">963f3a18-65dd-4aad-905c-b785cfe1d7c7:2571</guid><dc:creator>crestinul</dc:creator><slash:comments>0</slash:comments><comments>http://sqlserver.ro/forums/thread/2571.aspx</comments><wfw:commentRss>http://sqlserver.ro/forums/commentrss.aspx?SectionID=27&amp;PostID=2571</wfw:commentRss><description>&lt;P&gt;Aplicatia e in delphi.Folosesc componentele wmiset pt lucru cu wmi.&lt;/P&gt;
&lt;P&gt;O sa fac paste la codul pascal&lt;/P&gt;
&lt;P&gt;procedure tform1.rebootafterchange(machinename:string);&lt;BR&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; begin&lt;BR&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; wmiquery1.WQL.Clear;&lt;/P&gt;
&lt;P&gt;wmiquery1.WQL.Add('SELECT * FROM Win32_OperatingSystem' );&lt;BR&gt;wmiconnection1.MachineName:=machinename;&lt;BR&gt;if not&amp;nbsp; radiobutton2.Checked then&lt;BR&gt;begin&lt;BR&gt;if domain.text&amp;lt;&amp;gt;'' then&lt;BR&gt;wmiconnection1.Credentials.UserName:=domain.Text+'\'+username.Text&lt;BR&gt;else&lt;BR&gt;wmiconnection1.Credentials.UserName:=username.Text;&lt;BR&gt;wmiconnection1.Credentials.Password:=passwd.Text;&lt;BR&gt;end;&lt;BR&gt;wmiconnection1.Connected:=true;&lt;BR&gt;wmiquery1.Active:=true;&lt;BR&gt;wmimethod1.WmiMethodName:='Reboot';&lt;BR&gt;&amp;nbsp;wmimethod1.WmiObjectSource:=wmiquery1;&lt;BR&gt;&amp;nbsp;wmimethod1.Execute;&lt;BR&gt;wmiquery1.Active:=false;&lt;BR&gt;&amp;nbsp; wmiconnection1.Connected:=false;&lt;BR&gt;end&amp;nbsp;&amp;nbsp; ;&lt;/P&gt;
&lt;P&gt;Multumesc&lt;/P&gt;</description></item><item><title>Re: wmi help plsz</title><link>http://sqlserver.ro/forums/thread/2570.aspx</link><pubDate>Mon, 27 Aug 2007 16:06:14 GMT</pubDate><guid isPermaLink="false">963f3a18-65dd-4aad-905c-b785cfe1d7c7:2570</guid><dc:creator>B_gd_n[ ]Sahlean</dc:creator><slash:comments>0</slash:comments><comments>http://sqlserver.ro/forums/thread/2570.aspx</comments><wfw:commentRss>http://sqlserver.ro/forums/commentrss.aspx?SectionID=27&amp;PostID=2570</wfw:commentRss><description>&lt;p&gt;Ce valoare returneaza metoda StartService ?&lt;/p&gt;&lt;p&gt;Publica scriptul daca se poate.&amp;nbsp;&lt;/p&gt;</description></item><item><title>wmi help plsz</title><link>http://sqlserver.ro/forums/thread/2569.aspx</link><pubDate>Mon, 27 Aug 2007 15:25:43 GMT</pubDate><guid isPermaLink="false">963f3a18-65dd-4aad-905c-b785cfe1d7c7:2569</guid><dc:creator>crestinul</dc:creator><slash:comments>0</slash:comments><comments>http://sqlserver.ro/forums/thread/2569.aspx</comments><wfw:commentRss>http://sqlserver.ro/forums/commentrss.aspx?SectionID=27&amp;PostID=2569</wfw:commentRss><description>&lt;P&gt;Stiu ca nu e forumul potrivit.Dar am mai pus si pe alte forumuri dar nu mi s-a rapsuns.Am nevoie pentru o aplicatie de un sfat privind wmi poate ma poate ajuta cineva.&lt;/P&gt;
&lt;P&gt;uitati despre ce e vorba:&lt;/P&gt;
&lt;P&gt;.Trebuie sa fac disable/emable hardware device .AM folosit urmatoarea interogare wmi&lt;/P&gt;
&lt;P&gt;'SELECT * FROM Win32_SystemDriver WHERE Name='cdrom'&lt;/P&gt;
&lt;P&gt;imi returneaaza obiectu wmi cdrom.&lt;/P&gt;
&lt;P&gt;folosesc metodele wmi startservice si stopservice si reboot tot cu wmi daca se vrea pt a deveni activa operatiunea.&lt;/P&gt;
&lt;P&gt;Problema e ca merge numai stopservice adica dezactiveaza deviceul metoda startservice nu merge imi lasa deviceul disable&lt;/P&gt;
&lt;P&gt;Daca cumva cineva are experienta cu wmi&lt;/P&gt;
&lt;P&gt;Multumesc&lt;/P&gt;</description></item></channel></rss>