PowerBI - Conversion of data stamp powerbi

How to convert time stamp in Power BI

🔀

If you have the problem to get a date and time from  a database that is in Unix time stamp, the better way to use this data is convert in the PowerBI query editor.

Exchange 2010 error to mount the base after a bad shutdown

You get a error when you try to mount exchange data base.

Or event view ID 6 Exchange 2010

Error to mount a data base in exchange after a crash server or bad restart, there a 4 steps to resolve this usual problem.

• Remember after you get your base restored create another data store migrate all user for the new one.

Forcing the from address when postfix relays over smtp

Force to send all e-mail with the same email address.

accepted

This is how to really do it in postfix.

This config changes sender addresses from both local originated, and relayed SMTP mail traffic:

/etc/postfix/main.cf:

sender_canonical_classes = envelope_sender, header_sender
sender_canonical_maps =  regexp:/etc/postfix/sender_canonical_maps
smtp_header_checks = regexp:/etc/postfix/header_check

Rewrite envelope address from email originating from the server itself

/etc/postfix/sender_canonical_maps:

/.+/    newsender@address.com

Rewrite from address in SMTP relayed e-mail

/etc/postfix/header_check:

/From:.*/ REPLACE From: newsender@address.com

Clear Exchange 2013/2016/2019 Log & ETL Files

How to clean clean exchange LOG file run this script

Save as clearlog.ps1
Run as admin

Erro to deploy a code using AWS codedeploy Too few healthy instances / Signature not yet current:

AWS codedeploy

The overall deployment failed because too many individual instances failed deployment, too few healthy instances are available for deployment, or some instances in your deployment group are experiencing problems.




The solution:
1) check the service log
sudo tail -f /var/log/aws/codedeploy-agent/codedeploy-agent.log

I found this in my log Signature not yet current:


2) Check the machine services
 sudo service codedeploy-agent status
3) check the machine time
sudo service ntp status

4) Update the codedeploy
sudo /opt/codedeploy-agent/bin/install auto


5)sudo apt install chrony
6) add in /etc/chrony/chrony.conf the 
server 169.254.169.123 prefer iburst
7)
sudo /etc/init.d/chrony restart

8)
sudo chronyc -a makestep
9)check the service
chronyc sources -v
and
chronyc tracking


Make a deploy and check the log.

Como listar todos os dominios de um DNS

Como listar todas as entradas de um dominio.


A Maneira mais facil é o comando host

host -a dominio.com


Exemplo
 host -a google.com
Trying "google.com"
Trying "google.com"
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 24361
;; flags: qr rd ra; QUERY: 1, ANSWER: 16, AUTHORITY: 0, ADDITIONAL: 8

;; QUESTION SECTION:
;google.com.                    IN      ANY

;; ANSWER SECTION:
google.com.             186     IN      A       172.217.17.142
google.com.             21599   IN      NS      ns4.google.com.
google.com.             21599   IN      NS      ns3.google.com.
google.com.             21599   IN      NS      ns2.google.com.

Error to remove Database Mailbox Exchange 2010

Try to remove a mail database in the exchange 2010 and have this error ?


--------------------------------------------------------
Microsoft Exchange Error
--------------------------------------------------------
The mailbox database 'Yourdatabase' cannot be deleted.



Yourdatabase
Failed
Error:
This mailbox database contains one or more mailboxes, mailbox plans, archive mailboxes, or arbitration mailboxes. To get a list of all mailboxes in this database, run the command Get-Mailbox -Database <Database ID>. To get a list of all mailbox plans in this database, run the command Get-MailboxPlan. To get a list of archive mailboxes in this database, run the command Get-Mailbox -Database <Database ID> -Archive. To get a list of all arbitration mailboxes in this database, run the command Get-Mailbox -Database <Database ID> -Arbitration. To disable a non-arbitration mailbox so that you can delete the mailbox database, run the command Disable-Mailbox <Mailbox ID>. To disable an archive mailbox so you can delete the mailbox database, run the command Disable-Mailbox <Mailbox ID> -Archive. Arbitration mailboxes should be moved to another server; to do this, run the command New-MoveRequest <parameters>. If this is the last server in the organization, run the command Disable-Mailbox <Mailbox ID> -Arbitration -DisableLastArbitrationMailboxAllowed to disable the arbitration mailbox. Mailbox plans should be moved to another server; to do this, run the command Set-MailboxPlan <MailboxPlan ID> -Database <Database ID>.




--------------------------------------------------------
OK
--------------------------------------------------------

How to clean requests exchange 2010

Try to clean the old move requests
Get-MailboxExportRequest -Status Completed | Remove-MailboxExportRequest
Get-MailboxExportRequest -Status Failed | Remove-MailboxExportRequest

List inside of database

Get-MailboxDatabase "YOURDATABASE" | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount  >> C:\name_of_file.txt 

Ex: 
DisplayName                             TotalItemSize                                                         ItemCount
-----------                             -------------                                                         ---------
SystemMailbox{02d829c6-a6a6-4d5b-8c1... 98.84 KB (101,215 bytes)                                                     11
Microsoft Exchange Federation Mailbox   71.96 KB (73,687 bytes)                                                       3
Microsoft Exchange                      71.55 KB (73,267 bytes)                                                       3

Microsoft Exchange Approval Assistant   67.94 KB (69,573 bytes)                                                       3

1. Start the Active Directory Users and Computers snap-in.

2. On the View menu, make sure that Advanced Features is selected.

3. Locate the Microsoft Exchange System Objects container.

4. Delete the SystemMailbox {02d829c6-a6a6-4d5b-8c1 item

_____________________________


Sometimes

Start Exchange Management Shell and type the command to display mailboxes in the whole forest and not just the domain you are logged into:

[PS] C:Windowssystem32>$AdminSessionADSettings.ViewEntireForest=$True

[PS] C:Windowssystem32>Get-MailboxDatabase -Server nbc-d-mbx02

Name Server Recovery ReplicationType

—- —— ——– —————

Database15         NBC-D-MBX02 False None

[PS] C:Windowssystem32>Get-MailboxDatabase “nbc-d-mbx02Database15” | Get-Mailbox

Now that you have the list of all mailboxes in the exchange database, move it to a different server

To work around the Arbitration mailbox issue, let’s find out the list of all Arbitration mailboxes

[PS] C:Windowssystem32>Get-Mailbox -Arbitration |ft Name, Servername

Name ServerName

—- ———-

SystemMailbox{1f05a927-0695-4348-bb62-d2369dcb23d5} nbc-d-mbx01

FederatedEmail.4c1f4d8b-8179-4148-93bf-00a95fa1e042 nbc-d-mbx01

SystemMailbox{e0dc1c29-89c3-4034-b678-e6c29d823ed9} nbc-d-mbx02

SystemMailbox{bb558c35-97f1-4cb9-8ff7-d53741dc928c} nbc-d-mbx02

Migration.8f3e7716-2011-43e4-96b1-aba62d229136 nbc-d-mbx02

Now will disable all of those since I do not have a different server to move them to.

[PS] C:Windowssystem32>Disable-Mailbox “SystemMailbox{e0dc1c29-89c3-4034-b678-e6c29d823ed9}” -Arbitration -DisableLastArbitrationMailboxAllowed

Confirm

Are you sure you want to perform this action?

Disabling mailbox “SystemMailbox{e0dc1c29-89c3-4034-b678-e6c29d823ed9}” will remove the Exchange properties from the Active Directory user object and mark the mailbox in the database for removal. If the mailbox has an archive or remote archive, the archive will also be marked for removal. In the case of remote archives, this action is permanent. You can’t reconnect this user to the remote archive again.

[Y] Yes [A] Yes to All [N] No [L] No to All [?] Help (default is “Y”): a

[PS] C:Windowssystem32>Disable-Mailbox “SystemMailbox{bb558c35-97f1-4cb9-8ff7-d53741dc928c}” -Arbitration -DisableLastArbitrationMailboxAllowed

Confirm

Are you sure you want to perform this action?

ERROR EVENT ID 7023

Le service Carte de performance WMI s’est arrêté avec l’erreur :

%%-2147467259

EVENT ID 7023

Open CMD as Admin, Type Lodctr /r. You should get a message that it's repaired from a backup. You might see errors in the event logs but they stop after 10-15 minutes.

https://support.microsoft.com/en-us/help/300956/how-to-manually-rebuild-performance-counter-library-values

Rebuild the base performance counters

Extensible counter information is stored in both of the following locations:

• The following registry subkey:
  HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\009
• The %Systemroot%\System32\Perfc009.dat file and the %Systemroot%\System32\Perfh009.dat file

To rebuild the base performance counter libraries manually, follow these steps:

1. Expand the Perfc009.dat file and the
   Perfh009.dat file. These files are located on the Windows Installation Disc. The compressed files are found at DriveLetter:\i386\perfc009.da_ and at DriveLetter:\i386\perfh009.da_. Replace the files that are in the %Systemroot%\System32 folder.
2. Start Registry Editor, and then locate the following key in the registry:
   HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib
3. In the registry, change the Last Countervalue to 1846 (decimal), and change the Last Help value to 1847 (decimal).
4. Locate the following registry key to search for services that have a Performancesubkey:
   HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services

Windows 10 slow to refresh after copy/move files.

Win10 recently installed I realize that most of the times I copy/move/delete a file/folder the Win Explorer doesn't refresh by itself getting me to use F5 to checkout the status.

Opendedup sdfs java.lang.numberformatexception

Error  sdfs java.lang.numberformatexception

Running Program SDFS Version 3.0.4

reading config file = /etc/sdfs/sdfs0-volume-cfg.xml

java.lang.NumberFormatException: For input string: "1,95"

        at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043)

        at sun.misc.FloatingDecimal.parseFloat(FloatingDecimal.java:122)

        at java.lang.Float.parseFloat(Float.java:451)

        at org.opendedup.util.StringUtils.parseSize(StringUtils.java:64)

        at org.opendedup.sdfs.io.Volume.<init>(Volume.java:190)

        at org.opendedup.sdfs.Config.parseSDFSConfigFile(Config.java:365)

        at org.opendedup.sdfs.servers.SDFSService.start(SDFSService.java:39)

        at fuse.SDFS.MountSDFS.setup(MountSDFS.java:200)

        at fuse.SDFS.MountSDFS.init(MountSDFS.java:235)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:497)

        at org.apache.commons.daemon.support.DaemonLoader.load(DaemonLoader.java:207)

Exiting because java.lang.NumberFormatException: For input string: "1,95"

Service exit with a return value of 255