Monday

5

Solutions

36

Contributors

We're obsessed with building an excellent product, and our goal is to create a tool that people will love to use—one that’s fast, beautiful, responsive, and makes your life easier. The only thing we love more than our product is our customers. The incredible teams that use our product are the most important thing to us, and we're here to provide support to them 24/7.

Share tech news, updates, or what's on your mind.

Sign up to Post

Background:
Backup Exec version 20.0 1188.1863
Exchange2010

Issues
Full Backup file Fail w/ the following messages:
---------------------------------------------------------
 The consistency check of the snapshot for the Microsoft Exchange database Database was successful.
Monday, May 20, 2019 9:37:17 AM - V-79-57344-65247 - A failure occurred reading an object.

Monday, May 20, 2019 9:37:18 AM - WARNING: "\\concor-ex.XXXdomain.net\Microsoft Information Store\Mailbox Database 1\Database" is a corrupt file. This file cannot verify.
The consistency check of the snapshot for the Microsoft Exchange transaction log Logs ( E0000803337.log - E00008037B8.log ) has failed.  You should check for possible data corruption in the transaction log that is online.
-------------------------------------------------------

The Exchange seems running ok but can't backup

What is the issue with the exchange transaction log?
How can I solve it?
0
SQL View to group employees and show days for range.
I have my SQL View which is showing me the data that I want however it is not formatting how I would want it and I am at a brick wall with it -

Here is my sql
SELECT DISTINCT 
                          dbo.EMPLOYEELIST.EMPLOYEE_NAME,
                        
						 dbo.EMPLOYEELIST.ACTIVE, 
						 CASE WHEN cast(dbo.TimeEntered.Monday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Monday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Monday  as date)
						 END AS MONDAY,
						  CASE WHEN cast(dbo.TimeEntered.Tuesday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Tuesday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Tuesday  as date)
						 END AS Tuesday,
						 	  CASE WHEN cast(dbo.TimeEntered.Wed  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Wed  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Wed  as date)
						 END AS Wednesday,
						 	 	  CASE WHEN cast(dbo.TimeEntered.Thursday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Thursday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Thursday  as date)
						 END AS Thursday,
						 	 	 	  CASE WHEN cast(dbo.TimeEntered.Friday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Friday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Friday  as date)
						 END AS Friday,
					

Open in new window

0
Good morning all,

So I have a new issue, Shocker with it being a Monday Morning and all. I've been told that I need to change site codes for a number of OU's and change the associated groups which reside either in that OU or somewhere else.

Now

I need to change only the site part of the group, i'm kind of debating deleting and recreating the groups however in the (Likely) event that I'll need to do this again I'm trying to make it self contained.

$OUs = Read-Host "Please enter the OU and Associated groups you'd like to change"

$NewOU = Read-Host "Please enter the new name of the OU and groups"

Foreach ($OU in $OUs){
Get-ADOrganizationalUnit -filter "Name -like $ou" | Set-ADOrganizationalUnit -DisplayName $NewOU }

Get-ADGroup -filter "Name -like $ou"

Open in new window



This is where I've got to and it's pretty shocking, maybe because I broke myself on Friday night and I've still got a headache.

Any hints on how I can do this would be great. I'm still trying to learn the intricacies of PowerShell so please advise rather than giving the straight answer :D

I don't think this is a hash group thing either.

Thanks
ALex
1
I want to add a conditional formatting to the cells in column G ( 7 - 22) . I want the cells to highlight a certain color blue (RGB 183, 222, 232) if the ship date in column H is delinquent based on today's date OR if the ship date carries through to Sunday of that week. For example today is Monday, Sept 10th. The cells in column G should highlight if the ship date is through Sunday, Sept 16th.

Second, is it possible to also to write a formula in cell H31 to automatically sum up all cells that are highlighted in the blue in column G so that I don't have to manually do the sum each time I move lines around?

Third, is it possible to also to write a formula in cell H32 to automatically sum up all cells that are highlighted in the purple (RGB 204, 192, 218) in column K so that I don't have to manually do the sum each time I move lines around?

Fourth, is it possible to write a formula in cell G32 to automatically sum up all cells that are highlighted in the green (RGB 0, 255, 0) in column K so that I don't have to manually do the sum each time I move lines around?
FCS-TRAINING.xlsx
0
Hi Experts,
I had asked a question about First Monday & Third Monday of the week couple week ago and Expert Gustav Brock gave me the Public Function which works but when I tried to place to another form, it does not work as it suppose.  I know I did something wrong, but did not what I miss.  below is my code on a datefield:
Private Sub PDFIRSTCRTDATE_Exit(Cancel As Integer)
Dim DateInMonth As Date
DateInMonth = Date

    If Me.HoldCalA = "Cal 24" Or Me.HoldCalA = "Cal 42" Or Me.HoldCalA = "Cal 54" Then
       If Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 1, vbMonday) Or Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 3, vbMonday) Then
       Else
          MsgBox "You have schedule on the wrong Monday for the " & Me.HoldCalA & "."
       End If
    End If
  End Sub



Here is the Public Function from Gustav Brock:
' Calculates the date of the occurrence of Weekday in the month of DateInMonth.
'
' If Occurrence is 0 or negative, the first occurrence of Weekday in the month is assumed.
' If Occurrence is 5 or larger, the last occurrence of Weekday in the month is assumed.
'
' If Weekday is invalid or not specified, the weekday of DateInMonth is used.
'
' 2016-06-09. Gustav Brock, Cactus Data ApS, CPH.
'
Public Function DateWeekdayInMonth( _
    ByVal DateInMonth As Date, _
    Optional ByVal Occurrence As Integer, _
    Optional ByVal Weekday As VbDayOfWeek = -1) _
    As Date
   
    Const DaysInWeek    As Integer = 7
   
    …
0

Monday

5

Solutions

36

Contributors

We're obsessed with building an excellent product, and our goal is to create a tool that people will love to use—one that’s fast, beautiful, responsive, and makes your life easier. The only thing we love more than our product is our customers. The incredible teams that use our product are the most important thing to us, and we're here to provide support to them 24/7.

Top Experts In
Monday
<
Overall
>