"How to connect to WSUS SQL SERVER"
Como acessar o banco de dados do Windows Internal Database com o Management Tools
"How to connect to WSUS SQL SERVER"
uname -r |
sudo dpkg --list 'linux-image*' |
sudo dpkg -r linux-image-3.2.0-23-generic or sudo dpkg --force-depends --purge linux-image-3.2.0-23-generic |
104.171.126.17 104.238.225.10 104.238.225.24 104.238.225.25 104.238.225.2 104.238.225.6 104.36.224.234 107.191.50.124 107.191.56.166 108.61.189.43 108.61.192.4 108.61.215.86 109.224.116.210 151.236.57.213 167.114.54.13 173.208.185.87 177.137.24.64 177.220.193.50 178.79.136.84 178.79.189.47 184.172.155.227 185.91.118.111 185.92.220.170 185.92.221.102 186.209.95.182 191.252.30.161 192.95.49.171 201.157.248.172 201.157.249.126 201.157.249.137 201.157.249.140 201.157.249.147 201.157.249.148 201.157.249.155 201.157.249.162 201.157.249.170 201.157.249.172 201.157.249.179 201.157.249.181 201.157.249.182 201.157.249.190 201.157.249.215 201.157.249.232 201.157.249.235 201.157.249.248 201.157.249.31 201.157.249.40 201.157.249.41 201.157.249.71 201.157.249.92 201.157.250.137 201.157.250.143 201.157.250.145 201.157.250.175 201.157.250.17 201.157.250.182 201.157.250.185 201.157.250.221 201.157.250.229 201.157.250.235 201.157.250.246 201.157.250.249 201.157.250.43 201.157.250.4 201.157.250.6 201.157.255.103 201.157.255.105 201.157.255.108 201.157.255.127 201.157.255.128 201.157.255.134 201.157.255.14 201.157.255.157 201.157.255.162 201.157.255.173 201.157.255.176 201.157.255.177 201.157.255.17 201.157.255.198 201.157.255.20 201.157.255.21 201.157.255.229 201.157.255.231 201.157.255.239 201.157.255.42 201.157.255.4 201.157.255.51 201.157.255.57 201.157.255.6 201.157.255.76 201.157.255.89 201.157.255.97 212.71.252.82 212.71.255.81 213.219.36.207 42.0.164.183 45.32.232.43 45.32.233.168 45.32.235.14 45.32.238.98 45.32.246.148 50.22.129.206 50.23.177.15 50.23.177.28 50.23.177.8 76.164.231.36 88.80.187.136 104.238.216.60 104.238.216.61 104.238.216.62 201.157.248.103 201.157.248.113 201.157.248.120 201.157.248.124 201.157.248.126 201.157.248.128 201.157.248.133 201.157.248.157 201.157.248.16 201.157.248.17 201.157.248.181 201.157.248.184 201.157.248.192 201.157.248.233 201.157.248.247 201.157.248.34 201.157.248.35 201.157.248.47 201.157.248.49 201.157.248.70 201.157.248.86 201.157.248.86 201.157.248.91 65.36.241.14 54.149.191.238 104.223.45.193 104.223.45.214 104.223.45.214 104.238.216.61 104.238.216.61 104.238.216.61 104.238.216.62 179.109.216.134 179.109.216.136 179.109.221.78 179.109.223.65 179.109.223.65 179.109.240.139 179.109.240.140 179.109.240.147 179.109.240.80 179.109.246.185 177.136.42.0/24 177.20.182.0/24 177.20.183.26 177.53.211.179 177.92.151.171 179.107.46.75 187.108.200.192 187.17.64.75 |
Netshoes | PFinder <mkt@widetechs.com.br> Juliano Cabral <julianocabral@s.cluboferta.com.br> Saraiva.com.br | PFinder <mkt@widetechs.com.br> Marisa <mkt@widetechs.com.br> Ordenato <mkt@widetechs.com.br> Lumaê Pratas <mkt@widetechs.com.br> Vivo <mkt@jetmastik.com.br> Evino | PFinder <mkt@masktrail.com.br> Centauro | PFinder <mkt@senderwide.com.br> KD Pneus <mkt@convertsender.com.br> E Cadeiras <mkt@convertsend.com.br> OAB/SP eleições 12 <adv@hermesoposicao12.com.br> SAINT-GOBAIN <vendas@saintgobain.com.br> Easynvest <mkt@convertsender.com.br> Virtual Lingerie <mkt@convertsend.com.br> Marisa <mkt@convertsender.com.br> Netshoes | PFinder <mkt@convertsend.com.br> OAB/SP Chapa 12 <adv@hermesoposicao12.com.br> Cash Milhas <contato@pesquisamkt.com.br> Emporio da Cerveja <mkt@convertsend.com.br> Video e Foto para Eventos <bomdia@ag208.com.br> Portal Educação | Pós-Graduação <mkt@convertsender.com.br> Estadão <mkt@convertsend.com.br> Casa Santa Luzia <mkt@convertsend.com.br> Drogaria Onofre | PFinder <mkt@convertsender.com.br> Marcyn <mkt@convertsend.com.br> Hope Lingerie | PFinder <mkt@convertsender.com.br> Angeloni <mkt@convertsend.com.br> Seu Enxoval <mkt@convertsender.com.br> Beatriz Freitas <beatrizfreitas@n.tudoporvc.work> UW Casa das Cuecas <mkt@convertsender.com.br> Máximo Beneficios <mkt@convertsender.com.br> UOL PagSeguro <mkt@sendercomex.com.br> Marcyn <mkt@convertsender.com.br> Lumaê Pratas <mkt@convertsender.com.br> Giuliana Flores <mkt@sendercomex.com.br> Folha de S.Paulo <mkt@convertsender.com.br> E-lens <mkt@convertsender.com.br> Planos Corporativos Claro <contato@telefoniaideal.com.br> Prime Home Decor <mkt@convertsender.com.br> Pontofrio.com | PFinder <mkt@advanceprice.com.br> Portal Educação | Pós-Graduação <mkt@priceinbest.com.br> Extra.com.br | PFinder <mkt@advanceprice.com.br> Walmart.com.br | PFinder <mkt@advanceprice.com.br> Centauro | PFinder <mkt@advanceprice.com.br> Brastemp <mkt@priceinbest.com.br> Cursos 24 Horas <mkt@priceinbest.com.br> Zattini | PFinder <mkt@widelast.com.br> Amazon.com.br | PFinder <mkt@widelast.com.br> Emporio da Cerveja <mkt@priceinbest.com.br> Nike.com | PFinder <mkt@widelast.com.br> CasasBahia.com.br | PFinder <mkt@advanceprice.com.br> admin <super@a-facetime.com.br> Loja Online HP | PFinder <mkt@priceinbest.com.br> Evino | PFinder <mkt@widelast.com.br> Pontofrio.com | PFinder <mkt@advanceprice.com.br> Barred´s <mkt@widelast.com.br> Vivo <mkt@priceinbest.com.br> Seu Enxoval <jet@jetlinks.com.br> PontoFrio.com | PFinder <linco@lincolinks.com.br> FutFanatics <grow@growlinks.com.br> Hermes Barbosa <hermes.barbosa@barbosaadv.com.br> Polishop <linco@lincolinks.com.br> Ri Happy <grow@growlinks.com.br> Zattini | PFinder <jet@jetlinks.com.br> Extra.com.br | PFinder <linco@lincolinks.com.br> Beleza na Web | PFind <jet@jetlinks.com.br> Ricardo Eletro | PFinder <jet@jetlinks.com.br> news@srv85.ibxmx.com.br Dr. Leandro Pinto <auber109@gmail.com> P@R@N@2013 Netshoes | PFinder <mkt@trimnixx.com.br> Marisa <mkt@jetnixx.com.br> Estadão <mkt@trimnixx.com.br> Lara Bueno <lara.bueno@servidoreslocal. Barrocarte <contato@proteusmidcamp.com.br> Luiz Carlos <contato@phrcampserv.com.br> Moda Uno <mkt@spreadmark.com.br> Renata Leal - Corpo RH <contato@corporhtreinamentos.com.br> Renata Leal - Corpo RH <contato@corporhtreinamentos.com.br> Renata Leal - Corpo RH <contato@corporhtreinamentos.com.br> Renata Leal - Corpo RH <contato@corporhtreinamentos.com.br> Ricardo Eletro | PFinder <mkt@c> Netshoes | PFinder <mkt@spreadmark.com.br> Perder Peso Naturalmente <contato@agenciaspi02.com.br> Renata Leal <contato@phrcampserv.com.br> Hotel Fazenda Vilarejo <contato@proteusmidcamp.com.br> Consórcio Auto Fácil <contato@pesquisasemanal.com.br> Avaliamos os seus Imoveis <bomdia@ag211.com.br> Sem Parar | PFinder <mkt@wikimags.com.br> World Tennis <mkt@pressdaily.com.br> Valor Econômico <mkt@wikimags.com.br> Marisa <mkt@pressdaily.com.br> UW Casa das Cuecas <mkt@wikimags.com.br> Vivara <mkt@pressdaily.com.br> Máxino Beneficios <mkt@wikimags.com.br> Lumaê Pratas <mkt@pressdaily.com.br> Seu Enxoval <mkt@wikimags.com.br> Angeloni <mkt@wikimags.com.br> Jair Aguiar <jair-aguiar@rejuvelecimentok.com.br> Marcyn <mkt@pressdaily.com.br> Easynvest <mkt@wikimags.com.br> Condor <mkt@pressdaily.com.br> Prime Home Decor <mkt@wikimags.com.br> FutFanatics <mkt@pressdaily.com.br> Touch Watches <mkt@wikimags.com.br> Moda Uno <mkt@pressdaily.com.br> UW Casa das Cuecas <mkt@wikimags.com.br> Ricardo Eletro | PFinder <mkt@wikimags.com.br> Marisa <mkt@pressdaily.com.br> Michael McVey <mmcvey@cvisiontech.com> Vanuza Freitas <vanuzafreitas@salvocasamento.com.br> AMC Assessoria <amc_cobrancas@contato4.documentosdobem.com> Ri Happy <mkt@sendermark.com.br> Loja Online HP | PFinder <mkt@sendermark.com.br> Clube dos Testadores <mkt@sendermark.com.br> E-lens <mkt@sendermark.com.br> Hope | PFinder <mkt@sendermark.com.br> Yótica <mkt@sendermark.com.br> Giuliana Flores <mkt@sendermark.com.br> Ricardo Eletro | PFinder <mkt@sendermark.com.br> AMIL - Planos de Saúde <contato@microempresaindividual.com.br> |
DECLARE @TableName VARCHAR(255) DECLARE @sql NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 80 DECLARE TableCursor CURSOR FOR SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName FROM sys.tables OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN SET @sql = 'ALTER INDEX ALL ON ' + @TableName +' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')' EXEC (@sql) FETCH NEXT FROM TableCursor INTO @TableName END CLOSE TableCursor DEALLOCATE TableCursor GO |
sudo apt-get install munin |
sudo vim /etc/munin/munin.conf |
# Example configuration file for Munin, generated by 'make build' # The next three variables specifies where the location of the RRD # databases, the HTML output, logs and the lock/pid files. They all # must be writable by the user running munin-cron. They are all # defaulted to the values you see here. # dbdir /var/lib/munin htmldir /var/www/munin logdir /var/log/munin rundir /var/run/munin # # Where to look for the HTML templates # tmpldir /etc/munin/templates # (Exactly one) directory to include all files from. # includedir /etc/munin/munin-conf.d # Make graphs show values per minute instead of per second #graph_period minute # Graphics files are normaly generated by munin-graph, no matter if # the graphs are used or not. You can change this to # on-demand-graphing by following the instructions in # http://munin.projects.linpro.no/wiki/CgiHowto # #graph_strategy cgi # munin-cgi-graph is invoked by the web server up to very many times at the # same time. This is not optimal since it results in high CPU and memory # consumption to the degree that the system can thrash. Again the default is # 6. Most likely the optimal number for max_cgi_graph_jobs is the same as # max_graph_jobs. # #munin_cgi_graph_jobs 6 # If the automatic CGI url is wrong for your system override it here: # #cgiurl_graph /cgi-bin/munin-cgi-graph # munin-graph runs in parallel, the number of concurrent processes is # 6. If you want munin-graph to not be parallel set to 0. If set too # high it will slow down munin-graph. Some experiments are needed to # determine how many are optimal on your system. On a multi-core # system with good SCSI disks the number can probably be quite high. # #max_graph_jobs 6 # Drop somejuser@fnord.comm and anotheruser@blibb.comm an email everytime # something changes (OK -> WARNING, CRITICAL -> OK, etc) #contact.someuser.command mail -s "Munin notification" somejuser@fnord.comm #contact.anotheruser.command mail -s "Munin notification" anotheruser@blibb.comm # # For those with Nagios, the following might come in handy. In addition, # the services must be defined in the Nagios server as well. #contact.nagios.command /usr/bin/send_nsca nagios.host.comm -c /etc/nsca.conf # a simple host tree [localhost.localdomain] address 127.0.0.1 use_node_name yes # # A more complex example of a host tree # ## First our "normal" host. # [fii.foo.com] # address foo # ## Then our other host... # [fay.foo.com] # address fay # ## Then we want totals... # [foo.com;Totals] #Force it into the "foo.com"-domain... # update no # Turn off data-fetching for this "host". # # # The graph "load1". We want to see the loads of both machines... # # "fii=fii.foo.com:load.load" means "label=machine:graph.field" # load1.graph_title Loads side by side # load1.graph_order fii=fii.foo.com:load.load fay=fay.foo.com:load.load # # # The graph "load2". Now we want them stacked on top of each other. # load2.graph_title Loads on top of each other # load2.dummy_field.stack fii=fii.foo.com:load.load fay=fay.foo.com:load.load # load2.dummy_field.draw AREA # We want area instead the default LINE2. # load2.dummy_field.label dummy # This is needed. Silly, really. # # # The graph "load3". Now we want them summarised into one field # load3.graph_title Loads summarised # load3.combined_loads.sum fii.foo.com:load.load fay.foo.com:load.load # load3.combined_loads.label Combined loads # Must be set, as this is # # not a dummy field! # ## ...and on a side note, I want them listen in another order (default is ## alphabetically) # # # Since [foo.com] would be interpreted as a host in the domain "com", we # # specify that this is a domain by adding a semicolon. # [foo.com;] # node_order Totals fii.foo.com fay.foo.com # |
sudo vim /etc/munin/apache.conf |
Alias /munin /var/www/munin <Directory /var/www/munin> Order allow,deny # Allow from localhost 127.0.0.0/8 ::1 Allow from all Options None # This file can be used as a .htaccess file, or a part of your apache # config file. # # For the .htaccess file option to work the munin www directory # (/var/cache/munin/www) must have "AllowOverride all" or something # close to that set. # # AuthUserFile /etc/munin/munin-htpasswd # AuthName "Munin" # AuthType Basic # require valid-user # This next part requires mod_expires to be enabled. # # Set the default expiration time for files to 5 minutes 10 seconds from # their creation (modification) time. There are probably new files by # that time. # <IfModule mod_expires.c> ExpiresActive On ExpiresDefault M310 </IfModule> </Directory> |
|
|
ls /etc/munin/plugins |
ls /usr/share/munin/plugins/ |
Plugin | Used | Suggestions ------ | ---- | ----------- acpi | no | no [cannot read /proc/acpi/thermal_zone/*/temperature] amavis | no | no apache_accesses | yes | yes apache_processes | no | no apache_volume | yes | yes apc_envunit_ | no | no [no units to monitor] bonding_err_ | no | no [No /proc/net/bonding] courier_mta_mailqueue | no | no [spooldir not found] courier_mta_mailstats | no | no [could not find executable] courier_mta_mailvolume | no | no [could not find executable] cps_ | no | no cpu | yes | yes cpuspeed | no | no [missing /sys/devices/system/cpu/cpu0/cpufreq/stats/time_in_state] cupsys_pages | no | no [could not find logdir] df | yes | yes df_inode | yes | yes diskstats | yes | yes entropy | yes | yes exim_mailqueue | no | no [no exiqgrep] exim_mailstats | no | no [logdir does not exist] fail2ban | no | no [/usr/bin/fail2ban-client not found] forks | yes | yes fw_conntrack | no | yes fw_forwarded_local | no | yes fw_packets | yes | yes hddtemp_smartctl | no | no [smartctl not found] http_loadtime | yes | yes if_ | yes | yes (eth0 eth1) if_err_ | yes | yes (eth0 eth1) interrupts | yes | yes iostat | yes | yes iostat_ios | yes | yes ip_ | no | yes ipmi_ | no | no [no /usr/bin/ipmitool] irqstats | yes | yes jmx_ | no | no [java runtime not found at /usr/bin/java] load | yes | yes lpstat | no | no [lpstat not found] memory | yes | yes munin_stats | yes | yes mysql_ | no | no netstat | no | no nfs4_client | no | no [no /proc/net/rpc/nfs] nfs_client | no | no nfsd | no | no [no /proc/net/rpc/nfsd] nfsd4 | no | no [no /proc/net/rpc/nfsd] nginx_request | no | no [no nginx status on http://srv205/nginx_status] nginx_status | no | no [no nginx status on http://localhost/nginx_status] ntp_kernel_err | no | no ntp_kernel_pll_freq | no | no ntp_kernel_pll_off | no | no ntp_offset | no | no [no ntpq program] nvidia_ | no | no [no nvclock executable at /usr/bin/nvclock, please configure] open_files | yes | yes open_inodes | yes | yes postfix_mailqueue | no | no postfix_mailvolume | no | no [postfix not found] postgres_bgwriter | no | no postgres_cache_ | no | no postgres_checkpoints | no | no postgres_connections_ | no | no postgres_connections_db | no | no postgres_locks_ | no | no postgres_querylength_ | no | no postgres_scans_ | no | no postgres_size_ | no | no postgres_transactions_ | no | no postgres_tuples_ | no | no postgres_users | no | no postgres_xlog | no | no proc_pri | yes | yes processes | yes | yes ps_ | no | no qmailqstat | no | no selinux_avcstat | no | no [missing /selinux/avc/cache_stats file] sendmail_mailqueue | no | no sendmail_mailstats | no | no [no mailstats command] sendmail_mailtraffic | no | no [no mailstats command] slapd_ | no | no [Net::LDAP not found] slapd_bdb_cache_ | no | no [Can't execute db_stat file '/usr/bin/db4.6_stat'] slony_lag_ | no | no [DBD::Pg not found, and cannot do psql yet] smart_ | no | no [smartmontools not found] snort_alerts | no | no [/var/snort/snort.stats not readable] snort_bytes_pkt | no | no [/var/snort/snort.stats not readable] snort_drop_rate | no | no [/var/snort/snort.stats not readable] snort_pattern_match | no | no [/var/snort/snort.stats not readable] snort_pkts | no | no [/var/snort/snort.stats not readable] snort_traffic | no | no [/var/snort/snort.stats not readable] squeezebox_ | no | no [no connection on localhost port 9090] squid_cache | yes | no [could not connect: Connection refused] squid_objectsize | yes | no [could not connect: Connection refused] squid_requests | yes | no [could not connect: Connection refused] squid_traffic | yes | no [could not connect: Connection refused] swap | yes | yes threads | yes | yes tomcat_ | no | no uptime | yes | yes users | no | no varnish_ | no | no [which varnishstat returns blank] vmstat | yes | yes vserver_cpu_ | no | no [/proc/virtual/info not found] vserver_loadavg | no | no [/proc/virtual/info not found] vserver_resources | no | no [/proc/virtual/info not found] yum | no | no zimbra_ | no | no [No Text::CSV_XS] |
sudo ln -s /usr/share/munin/plugins/nome de plugin /etc/munin/plugins/ nome de plugin |
sudo ln -s /usr/share/munin/plugins/mysql_ /etc/munin/plugins/mysql_ sudo ln -s /usr/share/munin/plugins/squid_cache /etc/munin/plugins/squid_cache sudo ln -s /usr/share/munin/plugins/squid_icp /etc/munin/plugins/squid_icp sudo ln -s /usr/share/munin/plugins/traffic /etc/munin/plugins/traffic sudo ln -s /usr/share/munin/plugins/openvpn /etc/munin/plugins/openvpn sudo ln -s /usr/share/munin/plugins/squid_objectsize /etc/munin/plugins/squid_objectsize |
Virtual directory | Authentication method | SSL settings | Management method |
---|---|---|---|
Default website |
|
| IIS management console |
aspnet_client |
|
| IIS management console |
Autodiscover |
|
| Exchange Management Shell (Shell) |
ecp |
|
| Exchange admin center (EAC) or Shell |
EWS |
|
| Shell |
Microsoft-Server-ActiveSync |
|
| EAC or Shell |
OAB |
|
| EAC or Shell |
owa |
|
| EAC or Shell |
PowerShell |
|
| Shell |
Rpc |
|
| Shell |
RpcWithCert | By default, all authentication methods are disabled. |
|
Virtual directory | Authentication method | SSL settings | Management method |
---|---|---|---|
Default website |
|
| This virtual directory can’t be configured by the user. |
PowerShell |
|
| Shell |