When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
I have an IPhone, and when I watch YouTube on it, I can stream the video directly to my Smart TV. Since playing YouTube videos directly on Smart TV YouTube app is unpractical, I wondered If I could connect my Laptop with my Smart TV.And I did it with a help of Google Chrome. I …
In my last chapter I was talking about User AD account audit with power shell scripting and Task Scheduler. I also provided an list of Event IDs.This time I will show you how to create those notification through System Center Operations Manager. In OM Console open Authoring, the next thing is to go to rules …
For my Audit report, I had to create an audit list about creating,deleting,disabling,enabling,locking, unlocking my AD users. Since we haven’t had a SCOM on our premises, I hade to come up with something that will trigger an e-mail to me with an event.First of all you have to enable user auditing on Default GPO. After …
We virtualized one of our servers with VMM2012 P2V. Conversion went like a charm, but there was some IP problems.So, the VMM2012 converted NIC adapters, but he transferred addresses to Hyper-V Virtual Network adapter, because his physical adapters are no longer present.The server was up and running in virtual environment, but I hade to make …
I have a server with two IP addresses, one for internal network, one for external. But my server registers both IP addresses to DNS, and computers on internal network, sometimes get connection timeout.The problem was solved when I disabled the DNS registration on the other NIC. Go to TCP/IP v4 properties on NIC Hit …
I deinstalled VMM 2012 from one server. But its agents remained on my Hyper-V core installation servers. How to uninstall them if no Add/Remove programs exist, or you dont have original agent.msi package? On Core OS (2008 or 2012) run regedit Go to HKLM\Software\Microsoft\Windows\Current Version\Uninstall Expand Uninstall, then search in subfolders for string in DisplayName =”System …
I recently installed for testing, an SCOM 2012 agent on one machine. But I could not see that computer in Pending Management section. After searching through settings, I found out that you have to set Review new manual agent installation in pending management view in Settings->Securitiy in SCOM Console.
Today I had some problem of connecting to some of Windows 7 machines. The error I recieved was: The RPC server is unavailable. After searching some articles on the net, I found out that I need to enable RemoteAdmin firewall rule, and add DCOM TCP port 135 to Inbound rules. call netsh firewall set service …
I needed to get the list of my reports and what data source and dataset they use. use ReportServer; WITH XMLNAMESPACES ( DEFAULT ‘http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition’, ‘http://schemas.microsoft.com/SQLServer/reporting/reportdesigner’ AS rd ) SELECT distinct ReportName = name ,DataSetName = x.value(‘(@Name)[1]’, ‘VARCHAR(250)’) ,DataSourceName = x.value(‘(Query/DataSourceName)[1]’,’VARCHAR(250)’) ,CommandText = x.value(‘(Query/CommandText)[1]’,’VARCHAR(250)’) FROM ( SELECT C.Name,CONVERT(XML,CONVERT(VARBINARY(MAX),C.Content)) AS reportXML FROM ReportServer.dbo.Catalog C WHERE C.Content is …
Yesterday I installed CD Burner XP. After that I couldn’t mount ISO images anymore. The solution to this problem is in file association. Right click on ISO file, select properties; Choose button change on Opens with: From the list, choose Windows Explorer Close properties window, and then try the right click menu …