We help IT Professionals succeed at work.

Monday

10

Solutions

53

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.

I am having difficulties with Outlook. I was on the phone with Microsoft Tech. He temporarily disabled my second monitor for ease of troubleshooting. Issue was not fixed and will speak to L2 tech Monday. We disconnected then I noticed that my second monitor was still disabled.How do I restore the second monitor? Windows 10.
0
Is there a dynamic way to get the Monday of every week regardless of what day you execute a query?

What I am trying to do is get a range of time to always give me Monday of every week and go back 4 weeks. Any help would be greatly appreciated.

I have this now in my where clause for a date
between DATE_SUB((current_date() - INTERVAL WEEKDAY(NOW()) + 2 DAY), INTERVAL 27 DAY) and current_date() - INTERVAL WEEKDAY(NOW()) + 2 DAY

Open in new window


However, I know that there is a better way to do this because if I run this tomorrow it will be off.
0
I had to create a new CD.mdb database due to errors in the index.
I imported all tables, forms, queries, etc. successfully.  No index error found while compacting database.

I replicated the database to three other users, while keeping the design master on my computer.

When the other users open their replica, as error appears:   Missing or broken reference to OWC10.DLL.

How can I fix this problem?

Here are 2 images:

 Image 1
Image 2
I hope to resolve this before the users return to work on Monday.

Thank you for your help!
0
I have an older Dell server that I am now responsible for.

The box is a Dell PowerEdge 2950 with a SAS 6/iR

It has two drive configured for RAID-1. One of the virtual drives is degraded. My only options on the tasks for that drive are blink and unblink. I was looking for a way to rebuild this drive. If I check on the Enclosure/physical disks in the openmanage server administrator, the problem drive's state is listed as Foreign with Failure predicted. The client has replaced this drive twice and we get the same notification.

On the alert log for that drive, there is the following description:
SAS port report: SAS wide port 0 lost link on PHY 0.: Controller 0 (SAS 6/iR Intergrated)
that's followed by
SAS port report: SAS wide port 0 restored link on PHY 0.: Controller 0 (SAS 6/iR Intergrated)
After my login to the openmanage server we get
(with a green checkmark)
A foreign configuration has been detected.: Control 0
Virtual disk degraded: Virtual Disk 0
Predictive failure reported: Physical Disk 0:0:0 Controller 0, Connector 0

predictive failure sounds like a failing / failed drive but two new drive in a row? Seems a little strange.

I'm not very versed in Raid controllers. Most times when I have an issue, I've replaced the failing drive, it rebuilt itself and life went on.

Any assistance on how to resolve this for the client would be greatly appreciated.

At this point I only have remote access to the server via RDP. I can get to it onsite if…
0
Hi,
I would like to calculate the process duration and how long does it take excluding Weekend ( Friday and Saturday), I have used below function but it does not work specially if End date is "empty" and the process not completed... what i what to do is calculate the duration ( End date-Start date) excluding weekend(fri-Sat) and if end date is empty, (up-to-date - start date)
any help please

Public Function WorkdayDiff(ByVal d1 As Date, ByVal d2 As Date) As Long
  Dim diff As Long, sign As Long
  Dim wd1 As Integer, wd2 As Integer

  diff = DateDiff("d", d1, d2)
  If diff < 0 Then
    '* Effectively swap d1 and d2; reverse sign
    diff = -diff
    sign = -1
    wd1 = Weekday(d2)
  Else
    sign = 1
    wd1 = Weekday(d1)
  End If
  wd2 = (wd1 + diff - 1) Mod 7 + 1

  If (wd1 = 1 And diff = 0) Or (wd1 = 7 And diff <= 1) Then
    WorkdayDiff = 0 '* Both dates are on same weekend
    Exit Function
  End If

  '* If starting or ending date fall on weekend, shift to closest weekday
  '* since the weekends should not contribute to the sum.
  '* This shift is critical for the last If condition and arithmetic.
  If wd1 = 7 Then
    wd1 = 1 '* Shift to Monday
    diff = diff - 1
  ElseIf wd1 = 6 Then
    wd1 = 1 '* Shift to Monday
    diff = diff - 1
  End If

  If wd2 = 1 Then
    diff = diff - 1 '* Shift to Friday
  ElseIf wd2 = 7 Then
    diff = diff - 2 '* Shift to Friday
  End If

  '* If difference goes beyond weekend boundary then...
0
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

10

Solutions

53

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.