office 365 – Get user profile from Given name Flow

I was reading some forums where all the answers says that the UPN is something as jon_doe@example.com but all I have its a name ie Jon Doe. I’m trying to get the email using a name, but I don’t seem to do it correctly or I don’t know if this is even possible right now. I’m trying to do this because the flow currently puts the Name value directly into the field but when there are two or more options for the same person (ie the person has two accounts, one for admin rights and one normal) gives an error, using the email will get rid of this error since email is a unique value.

enter image description here

What UI/UX Designers do in office besides designing?

First of all, I apologize if the question is off-topic. I am struggling and couldn’t find the right platform nor reading materials on this topic.

How can UI/UX Designer stay inspired, motivated and active during the peak and off-peak season?

Peak Season

As a sole UI/UX designer, I am usually very busy, especially during the early and mid-phase of the product design timeline. However, towards the end; development stage (this could take months), there seems not much a designer can do besides the UI/UX quality check on the staging environment for the new product, updating styleguide and other design documents. I am also spending time learning and reading to improve UI/UX knowledge daily.

Off-peak Season

I also have the same issue about the designer duties when there is no new products in production. While the developers deal bug fixing on a day-to-day basis, I’m not sure what can a designer do daily during the off-peak season. I even offer help to the marketing team for any design works.

Again, I apologized if this type of question is not suitable here. I am hoping if others who have experienced this have advice or insights to share.

Thank you in advance.

datetime – Office Hours in PostgreSQL

What you want to do is something like this (all the code below is available on the fiddle here):

CREATE TABLE work_calendar
(
  the_day    DATE NOT NULL PRIMARY KEY,
  day_name   TEXT NOT NULL,
  start_time TIME NOT NULL,
  end_time   TIME NOT NULL
);

and for bank_holidays:

CREATE TABLE bank_holiday
(
  the_day TEXT NOT NULL,
  bh_date DATE NOT NULL
);

INSERT INTO bank_holiday 
VALUES
('New Year''s Day',    '2021-01-01'::DATE),
('St. Patrick''s Day', '2021-03-17'::DATE),
('Easter Monday',      '2021-05-04'::DATE),
('May Day',            '2021-05-01'::DATE),
('Christmas Day',      '2021-12-25'::DATE),
('St. Stephen''s Day', '2021-12-26'::DATE);

And then you can do the following:

BEGIN TRANSACTION;   -- discussed below!
WITH t (opening_day) AS
(
  SELECT  GENERATE_SERIES
  (
    '2021-01-01'::DATE,
    '2021-12-31'::DATE,
    '1 DAY'
  ) AS ds
)
INSERT INTO work_calendar
SELECT 
  opening_day,
  TO_CHAR(opening_day, 'Day'),
      
  CASE 
    WHEN EXTRACT(DOW FROM opening_day) IN (1, 2, 3, 4, 5) THEN '09:00:00'::TIME
    WHEN EXTRACT(DOW FROM opening_day) = 6                THEN '10:00:00'::TIME
    ELSE                                                       '00:00:00'::TIME
  END AS ot,
    
  CASE 
    WHEN EXTRACT(DOW FROM opening_day) IN (1, 2, 3, 4, 5) THEN '18:00:00'::TIME
    WHEN EXTRACT(DOW FROM opening_day) = 6                THEN '15:00:00'::TIME
    ELSE                                                       '00:00:00'::TIME
  END AS ct
FROM t;
COMMIT; -- discussed below.

And to check:

SELECT * FROM work_calendar ORDER BY the_day;

Result:

the_day day_name    start_time  end_time
2021-01-01  Friday      09:00:00    18:00:00
2021-01-02  Saturday    10:00:00    15:00:00
2021-01-03  Sunday      00:00:00    00:00:00
2021-01-04  Monday      09:00:00    18:00:00

So, we can see that we have the appropriate hours for the given day – i.e. weekday, 09:00 – 18:00, Saturday, 10:00 to 15:00 and nothing on Sunday.

Now, we haven’t taken the Christmas period (10:00 – 13:00) into account:

UPDATE work_calendar
SET start_time = '10:00:00', end_time = '13:00:00' 
WHERE (the_day >= '2021-12-24' AND the_day <= '2021-12-31') 
AND EXTRACT(DOW FROM the_day) NOT IN (0, 6);

And also, we haven’t taken bank holidays into account, so we do the following:

UPDATE work_calendar 
SET start_time = '00:00:00'::TIME, end_time = '00:00:00'
FROM bank_holiday
WHERE work_calendar.the_day = bank_holiday.bh_date;

And to check:

SELECT * FROM work_calendar ORDER BY the_day;

Result:

the_day day_name    start_time  end_time
2021-01-01  Friday      00:00:00    00:00:00   <<-- Bank Holiday
2021-01-02  Saturday    10:00:00    15:00:00
2021-01-03  Sunday      00:00:00    00:00:00
2021-01-04  Monday      09:00:00    18:00:00
2021-01-05  Tuesday     09:00:00    18:00:00

So, now we see that the New Year’s day bank holiday has been changed from above to nothing for either start_time or end_time as you would expect for a bank holiday. Obviously, you can choose bank holidays which will suit your own particular country/locale.

We can also check the Christmas period:

SELECT * FROM work_calendar WHERE the_day >= '2021-12-21'::DATE;

Result:

the_day day_name    start_time  end_time
2021-12-21  Tuesday     09:00:00    18:00:00
2021-12-22  Wednesday   09:00:00    18:00:00
2021-12-23  Thursday    09:00:00    18:00:00
2021-12-24  Friday      10:00:00    13:00:00  <<--- now, from finish at 13:00
2021-12-25  Saturday    00:00:00    00:00:00  <<--- not a work day - as expected!
2021-12-26  Sunday      00:00:00    00:00:00
2021-12-27  Monday      10:00:00    13:00:00
2021-12-28  Tuesday     10:00:00    13:00:00
2021-12-29  Wednesday   10:00:00    13:00:00
2021-12-30  Thursday    10:00:00    13:00:00
2021-12-31  Friday      10:00:00    13:00:00

So, the 10:00 to 13:00 times are correct – and Christmas Day (Sat.) is not worked.

You can run all of the above in one transaction to ensure ACID features – however, since it’s a one-off, that’s probably not a priority in this case? You can put the UPDATE before the end of the transaction with the BEGIN TRANSACTION; and the COMMIT;.

It could be done in one pass – but in this case, as it’s a one-off, it’s probably not worthwhile – but I can provide the code if necessary – let me know!

catalina – macOS Keynote, Pages, Numbers, and Microsoft Office apps will not open

From time to time out of the blue all these apps stop open. Other apps like Transmission, Safari, VLC and Mail seem fine as do other preinstalled apps.
Until recently after the system restart everything was working fine, but not anymore. Have 389 GB of free HDD space. I see Sophos mentioned in the reports below (don’t understand the meaning of it…): can it be the culprit, by any chance?
I am lost completely, and do need your help, please.

Before the system restart:

EtreCheck version: 3.4.6 (460)
Report generated 2021-05-01 17:45:49
Download EtreCheck from https://etrecheck.com
Runtime: 30:56
Performance: Poor

Click the (Lookup) links for more information from Apple Support Communities.
Click the (Details) links for more information about that line.
Click the (Remove/Report) links to remove adware or update the whitelist of legitimate software.

Hardware Information: ⓘ
Mac mini (Late 2012)
(Technical Specifications) – (User Guide) – (Warranty & Service)
Mac mini – model: Macmini6,2
1 2.6 GHz Quad-Core Intel Core i7 (i7-3720QM) CPU: 4-core
16 GB RAM Upgradeable – (Instructions)
BANK 0/DIMM0
8 GB DDR3 1600 MHz ok
BANK 1/DIMM0
8 GB DDR3 1600 MHz ok
Handoff/Airdrop2: supported
Wireless: en1: Unknown
iCloud Quota: 4.97 GB available

Video Information: ⓘ
Intel HD Graphics 4000 – VRAM: 1536 MB
HP ZR30w 2560 x 1600

Disk Information: ⓘ
APPLE HDD HTS541010A9E662 disk0: (1 TB) (Rotational)
(Show SMART report)
EFI (disk0s1 – MS-DOS FAT32) (EFI): 210 MB
(disk0s2) (APFS Container): 1000.00 GB

USB Information: ⓘ
USB20Bus
hub_device
hub_device
Apple, Inc. IR Receiver
Apple Inc. BRCM20702 Hub
Apple Inc. Bluetooth USB Host Controller
USB20Bus
hub_device
hub_device
USB30Bus
CP1500PFCLCD CRCA102-3I1

Thunderbolt Information: ⓘ
Apple Inc. thunderbolt_bus

Virtual disks: ⓘ
Macintosh HD – Data (disk1s1 – APFS) /System/Volumes/Data : 1000.00 GB (219.43 GB free)
Physical disk: disk0s2 1000.00 GB (219.43 GB free)
(disk1s2) (Preboot): 1000.00 GB
Physical disk: disk0s2 1000.00 GB
(disk1s3) (Recovery): 1000.00 GB
Physical disk: disk0s2 1000.00 GB
(disk1s4) /private/var/vm (VM): 1000.00 GB
Physical disk: disk0s2 1000.00 GB
Macintosh HD (disk1s5 – APFS) / (Startup): 1000.00 GB (219.43 GB free)
Physical disk: disk0s2 1000.00 GB (219.43 GB free)

System Software: ⓘ
macOS 10.15.7 (19H1030) – Time since boot: about 3 days

Gatekeeper: ⓘ
Mac App Store and identified developers

Possible adware: ⓘ
Unknown file: /System/Library/LaunchAgents/com.apple.SafariBookmarksSyncAgent.plist
/Library/Apple/System/Library/CoreServices/SafariSupport.bundle/Contents/MacOS/SafariBookmarksSyncAgent
One possible adware file found. (Remove/Report)

Kernel Extensions: ⓘ
/Library/Application Support/Logitech.localized/Logitech Options.localized
(loaded) com.logitech.manager.kernel.driver (8.20.1 – SDK 10.14) (Lookup)

    /Library/Extensions
(not loaded)    com.LaCie.ScsiType00 (1.2.13 - SDK 10.5) (Lookup)
(loaded)    com.sophos.kext.oas (10.0.2 - SDK 10.15) (Lookup)
(loaded)    com.sophos.kext.sfm (10.0.2 - SDK 10.15) (Lookup)
(loaded)    com.sophos.nke.swi (10.0.2 - SDK 10.15) (Lookup)

System Launch Agents: ⓘ
(running) com.apple.SafariBookmarksSyncAgent.plist (? 49b12d92 f6820329 – installed 2021-04-23)
(not loaded) 10 Apple tasks
(loaded) 169 Apple tasks
(running) 131 Apple tasks

System Launch Daemons: ⓘ
(failed) com.apple.metrickitd.plist (Apple, Inc. – installed 2020-09-21)
(not loaded) 34 Apple tasks
(loaded) 169 Apple tasks
(running) 130 Apple tasks

Launch Agents: ⓘ
(running) com.bjango.istatmenus.agent.plist (Bjango Pty Ltd – installed 2021-05-01) (Lookup)
(running) com.bjango.istatmenus.status.plist (Bjango Pty Ltd – installed 2021-05-01) (Lookup)
(running) com.logitech.manager.daemon.plist (Logitech Inc. – installed 2021-04-01) (Lookup)
(loaded) com.microsoft.OneDriveStandaloneUpdater.plist (Microsoft Corporation – installed 2021-03-06) (Lookup)
(not loaded) com.microsoft.update.agent.plist (Microsoft Corporation – installed 2021-03-18) (Lookup)
(running) com.sophos.agent.plist (Sophos – installed 2021-03-19) (Lookup)
(running) com.sophos.home.ui.plist (Sophos – installed 2021-03-19) (Lookup)

Launch Daemons: ⓘ
(loaded) com.apple.installer.osmessagetracing.plist (? dbb717cc 0 – installed 2019-10-28)
(running) com.bjango.istatmenus.daemon.plist (Bjango Pty Ltd – installed 2021-05-01) (Lookup)
(running) com.bjango.istatmenus.fans.plist (Bjango Pty Ltd – installed 2021-05-01) (Lookup)
(loaded) com.bjango.istatmenus.installerhelper.plist (Bjango Pty Ltd – installed 2021-05-01) (Lookup)
(running) com.microsoft.OneDriveStandaloneUpdaterDaemon.plist (Microsoft Corporation – installed 2021-03-06) (Lookup)
(loaded) com.microsoft.OneDriveUpdaterDaemon.plist (Microsoft Corporation – installed 2021-03-06) (Lookup)
(loaded) com.microsoft.autoupdate.helper.plist (Microsoft Corporation – installed 2021-03-18) (Lookup)
(loaded) com.microsoft.office.licensingV2.helper.plist (Microsoft Corporation – installed 2020-10-12) (Lookup)
(running) com.sophos.common.servicemanager.plist (Sophos – installed 2021-03-19) (Lookup)
(running) com.sophos.sophoscbr.plist (Sophos – installed 2021-03-19) (Lookup)

Internet Plug-ins: ⓘ
AdobePDFViewerNPAPI: 11.0.12 (installed 2015-07-14) (Lookup)
nplastpass: 4.1.2 (installed 2017-03-11) (Lookup)
AdobePDFViewer: 11.0.12 (installed 2015-07-14) (Lookup)

3rd Party Preference Panes: ⓘ
None

Time Machine: ⓘ
Time Machine not configured!

Top Processes by CPU: ⓘ
7% WindowServer
6% SophosScanDLegacy
4% kernel_task
4% Transmission
2% deleted

Top Processes by Memory: ⓘ
191 MB SophosScanDLegacy
132 MB WindowServer
128 MB Finder
124 MB MTLCompilerService
107 MB kernel_task

Top Processes by Network Use: ⓘ
Input Output Process name
2.66 GB 23 MB Transmission
1 MB 2 MB SophosMcsAgentD
1 MB 971 KB mDNSResponder
191 KB 92 KB (Microsoft Outloo)
128 KB 81 KB netbiosd

Top Processes by Energy Use: ⓘ
18.14 WindowServer
6.52 syspolicyd
6.46 ReportCrash
4.36 Transmission

Virtual Memory Information: ⓘ
10.31 GB Available RAM
15 MB Free RAM
5.69 GB Used RAM
10.30 GB Cached files
131 MB Swap Used

Software installs (last 30 days): ⓘ
VOX: 3.4 (installed 2021-04-03)
Enpass: 6.6.1 (installed 2021-04-03)
AdGuard for Safari: 1.9.13 (installed 2021-04-13)
Zoom: 5.6.3.706 (installed 2021-04-21)
The Unarchiver: 4.3.0 (installed 2021-04-24)
The Unarchiver: 4.3.1 (installed 2021-04-26)
The Unarchiver: 4.3.3 (installed 2021-04-30)

Install information may not be complete.

Diagnostics Events (last 3 days for minor events): ⓘ
2021-05-01 12:20:32 SophosServiceManager.app Crash (Open)
2021-04-30 16:51:52 Microsoft Outlook.app Hang (Open)
2021-04-29 10:43:18 Finder.app High CPU use (Open) (Details)
2021-04-29 09:44:36 signpost_reporter High CPU use (Open) (Details)
2021-04-28 18:44:59 Firefox.app Hang (Open)
2021-04-28 13:54:43 Kernel Panic (Open) (Details)
3rd Party Kernel Extensions: None
2021-04-28 13:51:33 Last shutdown cause: -62 – System unresponsive

Automatically generated report sent to Apple:

panic(cpu 2 caller 0xffffff7f828faaae): watchdog timeout: no checkins from watchdogd in 305 seconds (703 totalcheckins since monitoring last enabled), shutdown in progress
Backtrace (CPU 2), Frame : Return Address
0xffffff81defabc40 : 0xffffff8001d1763d
0xffffff81defabc90 : 0xffffff8001e51b25
0xffffff81defabcd0 : 0xffffff8001e436ae
0xffffff81defabd20 : 0xffffff8001cbda40
0xffffff81defabd40 : 0xffffff8001d16d07
0xffffff81defabe40 : 0xffffff8001d170f7
0xffffff81defabe90 : 0xffffff80024be898
0xffffff81defabf00 : 0xffffff7f828faaae
0xffffff81defabf10 : 0xffffff7f828fa486
0xffffff81defabf50 : 0xffffff7f8294ed9c
0xffffff81defabfa0 : 0xffffff8001cbd13e
Kernel Extensions in backtrace:
com.apple.driver.watchdog(1.0)(6C98691D-0510-3A98-9B62-C8FF0B9E3C99)@0xffffff7f828f9000->0xffffff7f82901fff
com.apple.driver.AppleSMC(3.1.9)(73E3419A-8963-3BB8-8538-1FFDEE1F8583)@0xffffff7f82941000->0xffffff7f8295ffff
dependency: com.apple.iokit.IOACPIFamily(1.4)(0BC116A3-534A-3990-99CB-09DB34A5EFAA)@0xffffff7f828f0000
dependency: com.apple.driver.watchdog(1)(6C98691D-0510-3A98-9B62-C8FF0B9E3C99)@0xffffff7f828f9000
dependency: com.apple.iokit.IOPCIFamily(2.9)(B4389948-0918-363E-8E70-0FBC89B384CA)@0xffffff7f82902000

BSD process name corresponding to current thread: kernel_task

Mac OS version:
19H1030

Kernel version:
Darwin Kernel Version 19.6.0: Mon Apr 12 20:57:45 PDT 2021; root:xnu-6153.141.28.1~1/RELEASE_X86_64
Kernel UUID: BB1171FD-A9E3-3D24-92F7-F4DD45974EFD
Kernel slide: 0x0000000001a00000
Kernel text base: 0xffffff8001c00000
__HIB text base: 0xffffff8001b00000
System model name: Macmini6,2 (Mac-F65AE981FFA204ED)
System shutdown begun: YES
Panic diags file available: YES (0x0)

System uptime in nanoseconds: 53866778455181
last loaded kext at 369402682856: com.sophos.kext.oas 10.0.2 (addr 0xffffff7f8524b000, size 49152)
last unloaded kext at 418213039604: >!AThunderboltDPOutAdapter 6.2.6 (addr 0xffffff7f842d4000, size 49152)
loaded kexts:
com.sophos.kext.oas 10.0.2
com.sophos.nke.swi 10.0.2
com.sophos.kext.sfm 10.0.2
com.logitech.manager.kernel.driver 8.20.1
@fileutil 20.036.15

AudioAUUC 1.70
!AGraphicsDevicePolicy 5.2.7
@AGDCPluginDisplayMetrics 5.2.7
!AHV 1
|IOUserEthernet 1.0.1
!AUpstreamUserClient 3.6.8
|IO!BSerialManager 7.0.6f8
!APlatformEnabler 2.7.0d0
AGPM 111.4.4
X86PlatformShim 1.0.0
!AMikeyHIDDriver 131
!AMCCSControl 1.14
pmtelemetry 1
!AMikeyDriver 283.15
!A!IHD4000Graphics 14.0.7
@Dont_Steal_Mac_OS_X 7.0.0
!AHDA 283.15
eficheck 1
!AThunderboltIP 3.1.4
!ASMCPDRC 1.0.0
|!ABCM5701Ethernet 10.3.5
!ALPC 3.1
AirPort.Brcm4360 1400.1.1
!AFWOHCI 5.6.2
!A!IFramebufferCapri 14.0.7
!A!ISlowAdaptiveClocking 4.0.0
@filesystems.autofs 3.0
!AIR!C 360
!AVirtIO 1.0
@filesystems.hfs.kext 522.100.5
@!AFSCompression.!AFSCompressionTypeDataless 1.0.0d1
@BootCache 40
@!AFSCompression.!AFSCompressionTypeZlib 1.0.0
@filesystems.apfs 1412.141.2
@private.KextAudit 1.0
!ASDXC 1.7.7
!AAHCIPort 341.140.1
!AACPIButtons 6.1
!ARTC 2.0
!AHPET 1.8
!ASMBIOS 2.1
!AACPIEC 6.1
!AAPIC 1.7
!A!ICPUPowerManagementClient 222.0.0
$!AImage4 1
@nke.applicationfirewall 303
$TMSafetyNet 8
@!ASystemPolicy 2.0.0
!A!ICPUPowerManagement 222.0.0
|EndpointSecurity 1
|IOAVB!F 850.1
@plugin.IOgPTPPlugin 840.3
DspFuncLib 283.15
@kext.OSvKernDSPLib 529
!ASMBus!C 1.0.18d1
|IOFireWireIP 2.3.0
|IONDRVSupport 576.1
@!AGPUWrangler 5.2.7
X86PlatformPlugin 1.0.0
!AHDA!C 283.15
|IOHDA!F 283.15
|IOEthernetAVB!C 1.1.0
IOPlatformPlugin!F 6.0.0d8
!ASMBusPCI 1.0.14d1
|IO80211!F 1200.12.2b1
|IOSkywalk!F 1
mDNSOffloadUserClient 1.0.1b8
corecapture 1.0.4
|IOFireWire!F 4.7.5
|IOAccelerator!F2 438.7.4
@!AGraphicsDeviceControl 5.2.7
|IOGraphics!F 576.1
!AGraphicsControl 5.2.7
|IOSlowAdaptiveClocking!F 1.0.0
@kext.triggers 1.0
|Broadcom!BHost!CUSBTransport 7.0.6f8
|IO!BHost!CUSBTransport 7.0.6f8
|IO!BHost!CTransport 7.0.6f8
usb.IOUSBHostHIDDevice 1.2
usb.networking 5.0.0
usb.!UHostCompositeDevice 1.2
usb.!UHub 1.2
|IOAudio!F 300.2
@vecLib.kext 1.2.0
|IOSerial!F 11
|IOSurface 269.11
@filesystems.hfs.encodings.kext 1
!AThunderboltDPInAdapter 6.2.6
!AThunderboltDPAdapter!F 6.2.6
!AThunderboltPCIDownAdapter 2.5.4
|IOAHCIBlock!S 316.100.5
!AThunderboltNHI 5.8.6
|IOThunderbolt!F 7.6.1
|IOAHCI!F 290.0.1
usb.!UEHCIPCI 1.2
usb.!UEHCI 1.2
usb.!UXHCIPCI 1.2
usb.!UXHCI 1.2
!AEFINVRAM 2.1
!AEFIRuntime 2.1
|IOSMBus!F 1.1
$quarantine 4
$sandbox 300.0
@kext.!AMatch 1.0.0d1
DiskImages 493.0.0
!AFDEKeyStore 28.30
!AEffaceable!S 1.0
!ASSE 1.0
!AKeyStore 2
!UTDM 489.120.1
|IOSCSIBlockCommandsDevice 422.120.3
!ACredentialManager 1.0
KernelRelayHost 1
!ASEPManager 1.0.1
IOSlaveProcessor 1
|IOTimeSync!F 840.3
|IONetworking!F 3.4
|IOUSBMass!SDriver 157.140.1
|IOSCSIArchitectureModel!F 422.120.3
|IO!S!F 2.1
|CoreAnalytics!F 1
!AMobileFileIntegrity 1.0.5
@kext.CoreTrust 1
IO!BHIDDriver 7.0.6f8
|IO!B!F 7.0.6f8
|IO!BPacketLogger 7.0.6f8
|IOUSBHIDDriver 900.4.2
|IOHID!F 2.0.0
|IOReport!F 47
|IOUSB!F 900.4.2
|IOUSBHost!F 1.2
!UHostMergeProperties 1.2
usb.!UCommon 1.0
!ABusPower!C 1.0
!AACPIPlatform 6.1
!ASMC 3.1.9
watchdog 1
|IOPCI!F 2.9
|IOACPI!F 1.4
@kec.pthread 1
@kec.Libm 1
@kec.corecrypto 1.0

After the system restart:

EtreCheck version: 3.4.6 (460)
Report generated 2021-05-02 17:09:44
Download EtreCheck from https://etrecheck.com
Runtime: 7:19
Performance: Below Average

Click the (Lookup) links for more information from Apple Support Communities.
Click the (Details) links for more information about that line.
Click the (Remove/Report) links to remove adware or update the whitelist of legitimate software.

Hardware Information: ⓘ
Mac mini (Late 2012)
(Technical Specifications) – (User Guide) – (Warranty & Service)
Mac mini – model: Macmini6,2
1 2.6 GHz Quad-Core Intel Core i7 (i7-3720QM) CPU: 4-core
16 GB RAM Upgradeable – (Instructions)
BANK 0/DIMM0
8 GB DDR3 1600 MHz ok
BANK 1/DIMM0
8 GB DDR3 1600 MHz ok
Handoff/Airdrop2: supported
Wireless: en1: Unknown
iCloud Quota: 4.97 GB available

Video Information: ⓘ
Intel HD Graphics 4000 – VRAM: 1536 MB
HP ZR30w 2560 x 1600

Disk Information: ⓘ
APPLE HDD HTS541010A9E662 disk0: (1 TB) (Rotational)
(Show SMART report)
EFI (disk0s1 – MS-DOS FAT32) (EFI): 210 MB
(disk0s2) (APFS Container): 1000.00 GB

USB Information: ⓘ
USB20Bus
hub_device
hub_device
Apple, Inc. IR Receiver
Apple Inc. BRCM20702 Hub
Apple Inc. Bluetooth USB Host Controller
USB20Bus
hub_device
hub_device
USB30Bus
CP1500PFCLCD CRCA102-3I1

Thunderbolt Information: ⓘ
Apple Inc. thunderbolt_bus

Virtual disks: ⓘ
Macintosh HD – Data (disk1s1 – APFS) /System/Volumes/Data : 1000.00 GB (387.17 GB free)
Physical disk: disk0s2 1000.00 GB (387.17 GB free)
(disk1s2) (Preboot): 1000.00 GB
Physical disk: disk0s2 1000.00 GB
(disk1s3) (Recovery): 1000.00 GB
Physical disk: disk0s2 1000.00 GB
(disk1s4) /private/var/vm (VM): 1000.00 GB
Physical disk: disk0s2 1000.00 GB
Macintosh HD (disk1s5 – APFS) / (Startup): 1000.00 GB (387.17 GB free)
Physical disk: disk0s2 1000.00 GB (387.17 GB free)

System Software: ⓘ
macOS 10.15.7 (19H1030) – Time since boot: about 2 hours

Gatekeeper: ⓘ
Mac App Store and identified developers

Possible adware: ⓘ
Unknown file: /System/Library/LaunchAgents/com.apple.SafariBookmarksSyncAgent.plist
/Library/Apple/System/Library/CoreServices/SafariSupport.bundle/Contents/MacOS/SafariBookmarksSyncAgent
One possible adware file found. (Remove/Report)

Kernel Extensions: ⓘ
/Library/Application Support/Logitech.localized/Logitech Options.localized
(loaded) com.logitech.manager.kernel.driver (8.20.1 – SDK 10.14) (Lookup)

    /Library/Extensions
(not loaded)    com.LaCie.ScsiType00 (1.2.13 - SDK 10.5) (Lookup)
(loaded)    com.sophos.kext.oas (10.0.2 - SDK 10.15) (Lookup)
(loaded)    com.sophos.kext.sfm (10.0.2 - SDK 10.15) (Lookup)
(loaded)    com.sophos.nke.swi (10.0.2 - SDK 10.15) (Lookup)

System Launch Agents: ⓘ
(running) com.apple.SafariBookmarksSyncAgent.plist (? 49b12d92 f6820329 – installed 2021-04-23)
(not loaded) 10 Apple tasks
(loaded) 185 Apple tasks
(running) 115 Apple tasks

System Launch Daemons: ⓘ
(not loaded) 34 Apple tasks
(loaded) 183 Apple tasks
(running) 117 Apple tasks

Launch Agents: ⓘ
(running) com.logitech.manager.daemon.plist (Logitech Inc. – installed 2021-04-01) (Lookup)
(loaded) com.microsoft.OneDriveStandaloneUpdater.plist (Microsoft Corporation – installed 2021-03-06) (Lookup)
(not loaded) com.microsoft.update.agent.plist (Microsoft Corporation – installed 2021-05-02) (Lookup)
(running) com.sophos.agent.plist (Sophos – installed 2021-03-19) (Lookup)
(running) com.sophos.home.ui.plist (Sophos – installed 2021-03-19) (Lookup)

Launch Daemons: ⓘ
(loaded) com.apple.installer.osmessagetracing.plist (? dbb717cc 0 – installed 2019-10-28)
(running) com.microsoft.OneDriveStandaloneUpdaterDaemon.plist (Microsoft Corporation – installed 2021-03-06) (Lookup)
(loaded) com.microsoft.OneDriveUpdaterDaemon.plist (Microsoft Corporation – installed 2021-03-06) (Lookup)
(loaded) com.microsoft.autoupdate.helper.plist (Microsoft Corporation – installed 2021-05-02) (Lookup)
(loaded) com.microsoft.office.licensingV2.helper.plist (Microsoft Corporation – installed 2020-10-12) (Lookup)
(running) com.sophos.common.servicemanager.plist (Sophos – installed 2021-03-19) (Lookup)
(running) com.sophos.sophoscbr.plist (Sophos – installed 2021-03-19) (Lookup)

Internet Plug-ins: ⓘ
AdobePDFViewerNPAPI: 11.0.12 (installed 2015-07-14) (Lookup)
nplastpass: 4.1.2 (installed 2017-03-11) (Lookup)
AdobePDFViewer: 11.0.12 (installed 2015-07-14) (Lookup)

3rd Party Preference Panes: ⓘ
None

Time Machine: ⓘ
Time Machine not configured!

Top Processes by CPU: ⓘ
18% WindowServer
13% TextEdit
6% kernel_task
4% mdsync
2% LogiMgrDaemon

Top Processes by Memory: ⓘ
395 MB firefox
309 MB SophosScanDLegacy
245 MB plugin-container
190 MB plugin-container
174 MB MTLCompilerService

Top Processes by Network Use: ⓘ
Input Output Process name
8 MB 2 MB tor.real
159 KB 312 KB SophosMcsAgentD
122 KB 51 KB (Microsoft Outloo)
34 KB 29 KB mDNSResponder
5 KB 38 KB apsd

Top Processes by Energy Use: ⓘ
4.88 WindowServer
3.86 mdsync
2.56 firefox
0.98 LogiMgrDaemon

Virtual Memory Information: ⓘ
10.08 GB Available RAM
2.86 GB Free RAM
5.92 GB Used RAM
7.22 GB Cached files
0 B Swap Used

Software installs (last 30 days): ⓘ
VOX: 3.4 (installed 2021-04-03)
Enpass: 6.6.1 (installed 2021-04-03)
AdGuard for Safari: 1.9.13 (installed 2021-04-13)
Zoom: 5.6.3.706 (installed 2021-04-21)
The Unarchiver: 4.3.0 (installed 2021-04-24)
The Unarchiver: 4.3.1 (installed 2021-04-26)
The Unarchiver: 4.3.3 (installed 2021-04-30)
Microsoft AutoUpdate: (null) (installed 2021-05-02)
Microsoft Excel: (null) (installed 2021-05-02)
Microsoft OneNote: (null) (installed 2021-05-02)
Microsoft PowerPoint: (null) (installed 2021-05-02)
Microsoft Word: (null) (installed 2021-05-02)
Microsoft Outlook: (null) (installed 2021-05-02)

Install information may not be complete.

Diagnostics Events (last 3 days for minor events): ⓘ
2021-05-02 14:32:55 Kernel Panic (Open) (Details)
3rd Party Kernel Extensions: None
2021-05-02 14:30:13 Last shutdown cause: -62 – System unresponsive
2021-05-02 14:06:46 Keynote.app Hang (Open)
2021-05-02 13:40:29 Microsoft Word.app Hang (Open)
2021-05-01 23:37:37 logd Crash (Open)
Cause: dyld3 mode
BUG IN LIBTRACE: Bad timesync db entry, file rotated
2021-05-01 21:39:44 Sophos Scan.app High CPU use (Open) (Details)
2021-05-01 12:20:32 SophosServiceManager.app Crash (Open)
2021-04-30 16:51:52 Microsoft Outlook.app Hang (Open)

How we save our office documents

Eh?

Just buy a box with a lid and put your paperwork in the box.

But wait….

When I look at your profile it says you sell custom boxes. What a coincidence!

 

security – What is a Tier 3 Office Administrator in connection with the azure enterprise model

I am currently architecting an enterprise model in Azure. I have noticed that the modified ESAE model has been extended a bit, but still does not contain Tier 3.

https://docs.microsoft.com/de-de/security/compass/privileged-access-access-model#tier-0-scope-expansion

For this reason, I am wondering why the following article talks about a Tier 3 Office Administrator (Sharepoint, Exchange, etc.). And at what security level do you think the admin should be classified?

https://docs.microsoft.com/de-de/azure/active-directory/privileged-identity-management/groups-features#activate-multiple-role-assignments-in-a-single-request

Thanks in advance for help

office 365 – How to you remove a Sharepoint Tenant

How do you remove a tenant from SharePoint?

I’ve read you can’t CHANGE a SharePoint Tenant but can you delete one and install a new one?

Ultimately I want to remove Company123.sharepoint.com and setup Company.sharepoint.com

  1. How to remove a tenant?
  2. Do I have to remove the tenant from ALL Microsoft 365 services?

sharepoint on prem – Error when opening Office documents from library through native client

We have a strange error on a Sharepoint 2013 farm since a few days. Opening documents using any native Office 2016 client (e.g. Word) does not work anymore. It shows the error below and they do not open at all. The documents can be opened in Web App mode however.

“There are network issues stopping us from opening your document. Please try again later.”

enter image description here

Any idea ?

office 365 – Microsoft Forms quiz can’t have Add “Other” option

I try to create a Microsoft Forms quiz with a question that has some fix choices and should have an Other choice with a text input.

At first I have already created a form in Microsoft Forms, and it had the choice, I was confident that a quiz can do this as well:

enter image description here

As I need to score the questions, I had to change to a quiz.

Surprisingly, the quiz looks a tiny bit different:

enter image description here

It looks that quiz can’t have the Add “Other” option (I’d guess, forms and quizes use the same engine under the hood so it could handle the ‘Other’ option)

I found this thread about the misterious disappering of the Add “Other” option in the recent version and some very vague effort to find it inside the rendering issues of the browser pages (what…?):

Try the tab button on your keyboard (it is the one often marked TAB on
your keyboard usually above the caps lock button, might just have left
and right arrows on it) to move from one box/field to the next until
you get to the bottom then you should see the Add option

According to them, Microsoft hid the button and it can be found on the page if you are lucky and persistent. Did they find the Add option button which was already there?

Can you tell if there is still hope to add a question with the Add “Other” option and with points?

teamwork – How to get up to speed quickly in new SE role, while: fully remote (COVID-19), in a satellite office, with time zones/language barrier to primary devs

Echoing a common question here – how to get up to speed at a new company.

I am curious if any particular tips stand out for the not-planned-work-from-home from COVID transition, or with cases where your department speaks a different language (and is timezone separated) from other parts of the organization.

Current efforts are mostly around reviewing documentation, but given language barrier some documents are not immediately useful (poor quality automatic translation) or not easily searchable, as well as often finding I need to request access permissions from another person whos work is shifted 12 hours after mine (so I get access to X the next day, only to find related links Y and Z which I then need to request).