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.