Tuesday, March 23, 2021

RSAT instalation

Open Powershell with Admin permissions and add the folowing:
Set Windows Update Server Key to 0

Set-ItemProperty -Path HKLM:SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU -Name UseWUServer -Value 0
Restart Windows Update Service
Restart-Service -Name wuauserv -Force
Get RSAT Tools
Get-WindowsCapability -Name RSAT* -Online | Add-WindowsCapability -Online
Set Windows Update Server Key to 1
Set-ItemProperty -Path HKLM:SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU -Name UseWUServer -Value 1
Restart Windows Update Service
Restart-Service -Name wuauserv -Force
Done

Thursday, September 26, 2019

SQL SSRS subscription to scheduled jobs query

SELECT  Schedule.ScheduleID AS JobName
       ,[Catalog].Name AS ReportName
       ,Subscriptions.Description AS Recipients
       ,[Catalog].Path AS ReportPath
       ,StartDate
       ,Schedule.LastRunTime
FROM    [ReportServer].dbo.ReportSchedule
        INNER JOIN [ReportServer].dbo.Schedule ON ReportSchedule.ScheduleID = Schedule.ScheduleID
        INNER JOIN [ReportServer].dbo.Subscriptions ON ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID
        INNER JOIN [ReportServer].dbo.[Catalog] ON ReportSchedule.ReportID = [Catalog].ItemID
                                                         AND Subscriptions.Report_OID = [Catalog].ItemID

Friday, June 23, 2017

Samsung S7 edge pink line

Started getting random pink line on my 10 month old phone.

Let's see if Samsung service is as good as Apple. Stay tuned traveling to NYC downtown to get it fixed.

Monday, May 2, 2016

How to get reportname from scheduled SQL job

SELECT
      c.Name AS ReportName
      , rs.ScheduleID AS JOB_NAME
      , s.[Description]
      , s.LastStatus
      , s.LastRunTime
FROM
      ReportServer..[Catalog] c
      JOIN ReportServer..Subscriptions s ON c.ItemID = s.Report_OID
      JOIN ReportServer..ReportSchedule rs ON c.ItemID = rs.ReportID
      AND rs.SubscriptionID = s.SubscriptionID

Monday, August 10, 2015

Galaxy s6 edge and google now

Well, s6 is a complete failure when it comes to Google now. I use finger print for security, guess what google now will not work. You can say ok Google and ask a question or make a command, but for result you have to unlock the phone. Issue was resolved with google update, took them a while