El Blog de JuanBO

Use msdb go select distinct j.Name as "Job Name", --j.job_id, case j.enabled when 1 then 'Enable' when 0 then 'Disable' end as "Job Status", jh.run_date as [Last_Run_Date(YY-MM-DD)] , case jh.run_status when 0 then 'Failed' when 1 then 'Successful' when 2 then 'Retry' when 3 then 'Cancelled' when 4 then 'In Progress' end as Job_Execution_Status from sysJobHistory jh, sysJobs j where j.job_id = jh.job_id and jh.run_date = ( select max (hi.run_date) from sysJobHistory hi where jh.job_id = hi.job_id )-- to get latest date

------------------------------ Data file size -------------------------- -- if exists ( select * from tempdb.sys.all_objects where name like '%#dbsize%' ) drop table #dbsize create table #dbsize (Dbname sysname,dbstatus varchar (50),Recovery_Model varchar (40) default ( 'NA' ), file_Size_MB decimal (30,2) default (0),Space_Used_MB decimal (30,2) default (0),Free_Space_MB decimal (30,2) default (0)) go insert into #dbsize(Dbname,dbstatus,Recovery_Model,file_Size_MB,Space_Used_MB,Free_Space_MB) exec sp_msforeachdb 'use [?]; select DB_NAME() AS DbName, CONVERT(varchar(20),DatabasePropertyEx(' '?' ',' 'Status' ')) , CONVERT(varchar(20),DatabasePropertyEx(' '?' ',' 'Recovery' ')), sum(size)/128.0 AS File_Size_MB, sum(CAST(FILEPROPERTY(name, ' 'SpaceUsed' ') AS INT))/128.0 as Space_Used_MB, SUM( size)/128.0 - sum(CAST(FILEPROPERTY(name,' ...

An exception occurred while updating addresses for connected app {6783ce5e-c88h-4021-8d5b-12614875cbfa_b79f19ab-1d40-4824-9911-3466cf8b070a}. The uri endpoint information may be stale. System.InvalidOperationException: The requested application could not be found.    at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ProcessCommonExceptions(Uri endpointAddress, String operationName, Exception ex, SPServiceLoadBalancerContext context)    at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ExecuteOnChannel(String operationName, CodeBlock codeBlock)    at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.GetEndPoints(Guid serviceId)    at Microsoft.SharePoint.SPConnectedServiceApplicationAddressesRefreshJob.Execute(Guid targetInstanceId) After de-commissioning some SharePoint servers, you might notice the above error on other WFEs /Application server’s event viewer . It appears that the SharePoint still has a reference...